Problem
A. Write a query using a WHERE clause that displays all the employees listed in the Wtable who have the job title Research and Development Engineer. Display the business entity ID number, the login ID, and the title for each one.
B. Write a query that displays all the rows from the War; table where the rows were modi?ed during the month of December in the year 2000. Display the business entity ID number, the name columns, and the modi?ed date.
C. Write a query displaying the order ID, order date and total due from W table where the total due exceeds $1,000. Retrieve only those rows where the salesperson ID is 279 or the territory ID is 6 or 4.
D. Write a query using the Wtable displaying the product ID, color, and name columns. If the color column contains a NULL value, replace the color with No Color.
E. Write a query that displays the Wand the name columns from the W table. Sort the results so that rows with a WM IN, SP, or SC sort by W The other rows should sort by FirstName. Hint: Use the CASE function.
F. Write a query that displays the product ID and Sales Order ID of all the products that have been ordered. Sales Order details for a product g be found in Wtable
G. Write a query that returns the W column from the Wtable along with every W from the W table.
H. Write a query that groups the products by Walong with a count. The products with the color blue or red need to be included. Display the rows that have a count that equals 1.