SDLC scope of the project

Lab 8-4

 

1. The following is a sample SELECT statement for the Orders relation:

 

SELECT o_num, c_num, o_date

FROM Orders; 

 

2. The following is a sample SELECT statement for the Orders relation:

 

SELECT *

FROM   Orders

WHERE s_num = 4;

 

3. The following is a sample SELECT statement for the Customers relation:

 

SELECT DISTINCT c_city FROM Customers;

 

4. The following is a sample SELECT statement for the Orders relation:

 

SELECT * FROM Orders

WHERE o_filled = 'false'

AND s_num = 1;