CiS 336 STUDy Learn Do Live /cis336study.com CiS 336 STUDy Learn Do Live /cis336study.com | Página 61

with two decimal places using the ROUND function. Sort by price
from lowest to highest.
5. Write a query that displays the customer_first_name,
customer_last_name, and customer_city from the customers table. Use
the LIKE operator to only display customers that reside in any zipcode
beginning with 4.
6. Write a query that displays the order id and order date for any
orders placed from March 1, 2014 through April 30, 2014. Do this
WITHOUT using the BETWEEN clause. Format the date field as
Month dd, yyyy and use