Question

5. Write a SELECT statement that returns these columns from the Orders table: OrderID OrderDate ShipDate Return only the rows where the ShipDate column contains a null value. 6. Write a SELECT statement that returns all columns from the Addresses table State is equal to CA 7. Write a SELECT statement that returns all columns from the Products table Product name has a "ru" in its name 8. Write a SELECT statement that returns these columns from the Customers table CustomerlD Firstname Lastname Email Address Return only the rows for customers whose first names are David, James and Art 9. Write a SELECT statement that answers this question: Which products have a list price that's greater than the average list price for all products? Return the Product Name and ListPrice columns for each product. Sort the results by the ListPrice column in descending sequence.

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Question 5 :

select OrderID,OrderDate,ShipDate from Orders where ShipDate is null;

Explanation :Above sql query will return columns from table where shipDate is null.

*****************************

Question 6 :

select * from addresses where state='CA';

Explanation :Above query will return all the columns from address table where state is CA.

************************

Question 7 :

select * from products where productName like '%ru%';

Explanation :Above query will return all the columns in the product table whoes product name contains ru in the name.

*********************************

Question 8 :

select CustomerID,Firstname,Lastname,EmailAddress from customers where firstname in ('David','James','Art');

Explanation :

*********************************

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.