Chapter 2, Problem 2AYK

For each filing segment, indicate in the table whether a cross-reference is needed. Then scroll down to the blank rows at the bottom of the table and fill in the necessary cross-references, in order, starting with the first blank row of the table. For each cross-reference, in the far left column of the table, fill in the original filing segment number followed by X. (For example, a cross-reference for filing segment 1. Would be labeled 1X). Then, fill in the filing segment and key units. Then , for each cross-reference, fill in the cross-reference note (“SEE…” or “SEE ALSO…”) in the column on the far right of the table. See the example filing segment and scroll down to see it’s corresponding cross-reference example.

Give names of manufacturers and their cities that are located in cities with names ending with 'City'. Give all the data for sales from January 21 of 2015 through the end of the month. (Use BETWEEN) List the information of each sale item where 2 or more items were sold but only for sizes 5, 6, and 7 (Use the keyword IN.) Show all sale item information. Give date and the sum of tax and shipping for each sale from December 20th through December 25th of 2015. (use BETWEEN. Name the calculated column SUM) Create an alphabetical list of names (first and last, alphabetized by last) of customers in Minnesota. What is the customerID for Sam Gill? What are the sales dates and shipping amount of sales with over $55 of shipping charges? List the data in the Salaried Employees table about Salaried Employees earning between $40000 and $50000. (use between) Give full names of customers that have a 'D' as the third character in their last names. Eliminate duplicates. Give names of manufacturers…

The APPT_DTTM column stores the date and time of an appointment. Which of the following expressions would return TRUE for all appointments on January 1, 2018, and FALSE for all other appointments? SELECT ONE OF THE FOLLOWING A. APPT_DTTM >= '1 JAN 2018' AND APPT_DTTM < '2 JAN 2018' B. APPT_DTTM = '1 JAN 2018' C. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM <= '1 JAN 2018' D. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM < '2 JAN 2018' Choose one correct answer and what is output of remaining queries with proper explanation