Tag: database
Database || Old Paper solution 2017
13. a. select pname from parts as p, suppliers as s, catalog as c where p.pid = c.pid and c.sid = s.sid GROUP by s.sid having count(p.pid) = 1; b. select sname from suppliers as s, catalog as c, parts as p where c.sid = s.sid and p.color = ‘red’; c. update catalog set cost […]
Continue ReadingDatabase Notes || BIM
1st Reference Notes 2nd Reference Notes
Continue ReadingDatabase || Old paper solution 2016
16. a) insert into users(‘Ram’, ‘12345’, ‘[email protected]’, ‘2002-01-01’, ‘m’, curdate()); b)SELECT * from users where dateOfBirth < ‘2000-01-01’; c) select categoryName from categories where categoryID not in (select categoryID from expenses)); d)select username from users where in(select userID from expenses where amount < (select amount from expenses where userID = 405)));
Continue Reading