Write a query to produce a list of all customer names in which the first letter of the first and last names is in uppercase and the rest are in lowercase.

Question $2$

$10$

Points

Write a query to ceate a list of all customer numbers along with text indicating whether the customer has been referred by another customer. Display the text $$NOT REFERRED$$ if the customer wasn$$t referred to the Books table by another customer or $$REFERRED$$ if the customer was referred.

Question $3$

$10$

Points

Write the query to determine the amount of total profit generated by the book purchased on order $1002.$ Display the book title and profit. The profit should be formatted to display a dollar sign and two decimal places. Take into account that the customer might not pay the full retail price, and each item ordered can involve multiple copies.

Question $4$

$10$

Points

Write a query to display a list of all book titles and the percentage of markup for each book. The percentage of markup should be displayed as a whole number $($that is$,$ multiplied by $100)$ with no decimal position, followed by a percent sign $($for example, $\mathrm{.}2793=28\%).($The percentage of markup should reflect the difference between the retail and cost amounts as a percent of the cost.$)$

Question $5$

$10$

Points

Write a query to display the current day of the week, hour, minutes, and seconds of the current date setting on the computer you$$re using $($This result should be different from all other students in theory$).$

Question $6$

$10$

Points

Write a query to create a list of all book titles and costs. Precede each book$$s cost with asterisks so that the width of the displayed Cost field is $12.$

Question $7$

$10$

Points

Write a query to determine the length of data stored in the ISBN field of the BOOKS table. Make sure each different length value is displayed only once $($not once for each book$).$

Question $8$

$10$

Points

Write a query to display today$$s date, determine the age $($in months$)$ of each book. Make sure only whole months are displayed; ignore any portions of months. Display the book title, publication date, current date, and age.

Question $9$

$10$

Points

Write a query to determine the calendar date of the next occurrence of Wednesday, based on today$$s date.

Question $10$

$10$

Points

Write a query to produce a list of each customer number and the third and fourth digits of his or her zip code. The query should also display the position of the first occurrence of a $3$ in the customer number, if it exists.