Question

Consider the table Projects given below. Write commands in SQL gor i) to vi) and output for vii) to x)

Answer 1

1. SELECT * FROM `projects` WHERE ProjSize = 'Medium';

2. SELECT ProjName, Projsize FROM projects WHERE cost >100000;

3. SELECT Projsize FROM projects WHERE ProjName LIKE '%LITL';

4. SELECT ID, ProjName, Projsize, Cost FROM projects ORDER BY StartDate DESC;

5. SELECT COUNT( * ) FROM projects WHERE Cost <100000;

6. SELECT * FROM  projects WHERE StartDate >2006;

7. SELECT SUM( Cost ) FROM projects;

8. SELECT DISTINCT Projsize FROM projects;

9. SELECT MAX( Cost ) FROM projects;

10. SELECT AVG( Cost ) FROM Projects GROUP BY Projsize;