below is a picture of what the customers table on the data base looks like.
Determine the SQL statements needed to perform the two required tasks below. Each statement should be tested to ensure validity Submit your SQL commands AND screenshot as documentation of your results for full credit. Remember to include your comment to explain your sql commands 1. Create a list from the Customers table that should display the name, address, city, state, and zip code for each customer Each customer's name should be listed in ordet format of last name followed by first name, separated with a comma, AND have the column headers "Customer's Name". "Customer's Address",Customer's State". Customer's Zip code" For example lastname, firstname is displayed in the column header as Customer's Narne". Address displayed in the next column header as "Customer's Address", and so on. ( 25 points) 2. Management needs to determine profits per book. To determine the percentage of profit for a particular item, subtract the item's cost from the retail price to calculate the dollar amount of profit by the item's cool The solution is then multiplied by 100 to determine the profit percentage for each book. Use a SELECT Matement to display cach book's tile and profit. For the column displaying the percentage markup, tase "My CTEC 3000 Profito" as the column heading (25 points) Worksheet Query Builder SELECT * FROM CUSTOMERS Script Output Query Result SQL All Rows Fetched: 20 in 0.005 seconds CUSTOMER: LASTNAME FIRSTNAME ADDRESS CITY STATE OZP 1 1001 MORALES BONITA P.O. BOX 651 EAST POINT EL 32326 2 -1002 THOMPSON RYAN P.O. BOX 9835 SANTA MONICA CA 90404 3 1003 SMITH LEILA P.O. BOX 66 TALLAHASSEX TL 32306 4 1004 PIERSON THOMAS 69821 SOUTH AVENUE BOISE ID 33707 5 1005 GIRARD CINDY P.O. BOX 051 SEATTLE 98115 6 1006 CRUZ MESHIA 92 DIRT ROAD ALBANTY NY 12211 7 1007 GIANA TAMMY 9153 MAIN STREET AUSTIN TX 78710 B 1008 JONES KENNETH P.O. BOX 137 CHEYENNE WY 82003 9 1009 PEREZ JORGE P.O. BOX 8564 BURBANK CA 91510 10 1010 LUCAS JARE 114 EAST SAVANNAH ATLANTA GA 30314 11 1011 MCGOVERN RELSE P.O. BOX 10 CHICAGO IL 60606 12 1012 MCKENZIE WILLIAM P.O. BOX 921 BOSTON MA 02110 13 1011 NGUYEN NICHOLAS 357 WHITE EAGLE AVE. CLERMONT 34711 14 1014 LEE JASMINE P.O. BOX 2947 CODY WY 15 1015 SCHELL STEVE P.O. BOX 677 MIAMI EL 33111 16 2016 DAM MICHELL 9851231 LONG ROAD BURBANK CA 93508 17 1017 NELSON BECCA P.O. BOX 563 KALMA200 MI 49006 18 1018 MONTIASA GREG 1008 GRAND AVENUE MACON GA 31206 19 1019 SMITH JELFER P.O. BOX 1151 MORRISTOWN 07962 20 1020 TALA P.O. Box 335 KENNETH NJ TRENTON 06607 REFERRED REGION (null) (null) (null) SE (null) W (null) (null) NE 1003 5W (null) 1000W (null) SE (null) N (null) NE 1006 SE (null) (null) SE 1010W (null) (null) SE 1003 NE (null) NE
