Filtering and Sorting Data
SQL Query - 1
SELECT stud_id, fname, lname FROM Student;
SQL Query - 2
SELECT stud_id, fname, lname, email, ph_no FROM Student WHERE joining_Year = 2018;
SQL Query - 3
SELECT * FROM Student WHERE course = 'CS400';
SQL Query - 4
SELECT stud_id, fname, lname, email, ph_no FROM Student WHERE joining_Year > 2000 AND lname = 'Daga';
SQL Query - 5
SELECT stud_id FROM Student WHERE joining_Year = 2016 OR course = 'CS101';
SQL Query - 6
SELECT * FROM Student WHERE joining_Year BETWEEN 2009 AND 2011;
SQL Query - 7
SELECT fname, lname, joining_Year, ph_no FROM Student WHERE DOB > '1998-11-02';
SQL Query - 8
SELECT emp_name, email FROM Emp_data WHERE contract='Intern';
SQL Query - 9
SELECT * FROM Emp_data WHERE contract='FTE' AND dept='D3';
SQL Query - 10
SELECT * FROM Emp_data WHERE dept = 'D1' OR dept='D3';
SQL Query - 11
SELECT fname, lname, course FROM Student WHERE stud_id IN (423,667,645,321,776);
SQL Query - 12
SELECT * FROM Emp_data WHERE dept IN ('D1','D2');
SQL Query - 13
SELECT * FROM Emp_data WHERE dept IN ('D1','D2');
SQL Query - 14
SELECT emp_name, dept FROM Emp_data WHERE hometown IN ('Mumbai','Jalandhar') AND emp_id < 900;
SQL Query - 15
SELECT fname,lname FROM Student WHERE fname LIKE '_s%';
SQL Query - 16
SELECT * FROM Student WHERE email LIKE '%yahoo%';
SQL Query - 17
SELECT * FROM Emp_data WHERE email LIKE 'fab%';
SQL Query - 18
Select emp_id, emp_name FROM emp_data WHERE email LIKE '%bcd%'
AND dept IN ('D3','D4')
AND hometown NOT IN ('Himachal','Guwahati');
SQL Query - 19
SELECT * FROM Student ORDER BY lname;
SQL Query - 20
SELECT * FROM Student ORDER BY fname, lname desc;
SQL Query - 21
SELECT email FROM Student WHERE joining_Year = 2005 ORDER BY DOB DESC;
SQL Query - 22
SELECT fname, lname FROM Student WHERE course ='CS206' AND joining_year =2019 ORDER BY dob, lname;
SQL Query - 23
SELECT order_id, ordered_time FROM e_transactions ORDER BY ordered_time;
SQL Query - 24
SELECT * FROM e_transactions ORDER BY shipping_time desc;
SQL Query - 25
SELECT * FROM e_transactions ORDER BY ordered_time desc, shipping_time;
SQL Query - 26
SELECT * FROM e_transactions WHERE cost < 5000 ORDER BY cost;
SQL Query - 27
SELECT order_id, shipping_time FROM e_transactions WHERE ordered_time<'2021-06-30'
ORDER BY cost, ordered_time desc;
SQL Query - 28
SELECT * FROM e_transactions WHERE ordered_time LIKE '%07%' OR ordered_time LIKE '%-02-%' ORDER BY cost ;
