Scribd
Upload
58 views3 pages

SQL Queries for Database Students

This document contains 20 SQL queries: 1. The first query selects all columns from the seller table. 2. Several queries select columns from tables and join them based on matching column values to filter rows. 3. The last few queries calculate aggregate values like average, count, maximum and compare column values.

Uploaded by

sanugakusalwin578
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
58 views3 pages

SQL Queries for Database Students

This document contains 20 SQL queries: 1. The first query selects all columns from the seller table. 2. Several queries select columns from tables and join them based on matching column values to filter rows. 3. The last few queries calculate aggregate values like average, count, maximum and compare column values.

Uploaded by

sanugakusalwin578
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

ISO 9001:2015 Certified Institute

JAVA INSTITUTE FOR ADVANCED TECHNOLOGY

DATABASE MANAGEMENT 1
H7DX 04
H7DX 04/AS/03

1. SELECT * FROM `seller`;

1|Page
2. SELECT `lname`,`color` FROM `laptop`;
3. SELECT `age` FROM `seller` INNER JOIN `seller_has_laptop` ON
seller.sid=seller_has_laptop.sid WHERE lid='102';
4. SELECT DISTINCT `sname` FROM `seller` INNER JOIN
`seller_has_laptop` ON seller.sid=seller_has_laptop.sid INNER JOIN
`laptop` ON seller_has_laptop.lid=laptop.lid WHERE color='red';
5. SELECT DISTINCT `color` FROM `laptop` INNER JOIN
`seller_has_laptop` ON laptop.lid=seller_has_laptop.lid INNER JOIN
`seller` ON seller_has_laptop.sid=seller.sid WHERE `sname`='nelum';
6.
7. SELECT DISTINCT `sname` FROM `seller` INNER JOIN
`seller_has_laptop` ON seller.sid=seller_has_laptop.sid INNER JOIN
`laptop` ON seller_has_laptop.lid=laptop.lid WHERE color='red' OR
color='blue' OR color='green';
8. SELECT `sname` FROM `seller` ORDER BY `sname` ASC;
9. SELECT DISTINCT `sname`,`age` FROM `seller` INNER JOIN
`seller_has_laptop` ON seller.sid=seller_has_laptop.sid INNER JOIN
`laptop` ON seller_has_laptop.lid=laptop.lid WHERE `color`='Red' OR
`color`='green';
10. SELECT DISTINCT `sname` FROM `seller` INNER JOIN
`seller_has_laptop` ON seller.sid=seller_has_laptop.sid INNER JOIN
`laptop` ON seller_has_laptop.lid=laptop.lid WHERE `age`> '30' AND
`color`!='red';
11. SELECT `sname` FROM `seller` INNER JOIN `seller_has_laptop` ON
seller.sid=seller_has_laptop.sid WHERE `lid`= (SELECT `lid` FROM
`laptop` WHERE `lname` = 'HP');
12. SELECT DISTINCT `seller`.sid FROM `seller` INNER JOIN
`seller_has_laptop` ON seller.sid=seller_has_laptop.sid WHERE rating
= '10' OR `lid`='103';
13. SELECT `color`,`sname`,`age` FROM `seller` INNER JOIN
`seller_has_laptop` ON seller.sid=seller_has_laptop.sid INNER JOIN
`laptop` ON seller_has_laptop.lid=laptop.lid WHERE
`seller_has_laptop`.lid='103';
14. SELECT `age` FROM `seller` ORDER BY `age` ASC;
15. SELECT DISTINCT `sname` FROM `seller` INNER JOIN
seller_has_laptop ON seller.sid = seller_has_laptop.sid INNER JOIN
laptop ON seller_has_laptop.lid = laptop.lid WHERE laptop.lid !=
'Red';
16. SELECT `sname` FROM `seller` WHERE `rating` > (SELECT `rating`
FROM `seller` WHERE `sname`='Seetha');

2|Page
17.
18. SELECT AVG(`age`) FROM `seller`;
19. SELECT COUNT(`sid`) FROM `seller`;
20. SELECT `age` FROM `seller` WHERE `age` > (SELECT MAX(`age`) FROM
`seller` WHERE `rating` = '10');

3|Page

You might also like