1 CIS111 Chapter 3 Homework This homework problem sheet is worth 10 points, each worth 2.5 points for a completed query. Only completed problems will receive maximum points. The queries are due per...

1 answer below »
h


1 CIS111 Chapter 3 Homework This homework problem sheet is worth 10 points, each worth 2.5 points for a completed query. Only completed problems will receive maximum points. The queries are due per the timeline in Moodle. The queries will use the AP database. Create an SQL statement to solve each problem. Don’t forget to: 1. The database used “USE” 2. Comment with the assignment name, query number and your name and date. 3. The SQL code 4. The output of the messages tab 5. First 5 lines of the “Results” output. Points will be deducted 1. Create a query that will display the Vendor city, State, and zipcode information within one column with the column heading of “Vendor Address”. Make sure it is displayed in the following format: Dearborn, MI Zip: 48128 The vendors listed should be from the city of San Francisco (California) whose zipcode ends with the digit 1 or 2. 2. Create a query that will display all fields from the Vendor table whose telephone number ends with 600 and is in California. 3. Create a query using the Vendor table that will only display the state field for all of the different states where the vendors are located. The output must only show the state one time (Distinct). 4. Create a query to display all fields of the Vendors table for those vendors who have a P.O. Box for any address and are from the state of Illinois (IL), Ohio (OH) or Michigan(MI). Order the list by Vendor state and by Vendor City.
Answered Same DayJan 31, 2022

Answer To: 1 CIS111 Chapter 3 Homework This homework problem sheet is worth 10 points, each worth 2.5 points...

Kshitij answered on Feb 01 2022
107 Votes
1.select concat(city,cancat(', ', concat(state, concat('Zip: ', concat(zipcode,' '))))) as vendor address from vendror (right(zipcode,1)) in ('1', '2') and city='San Francisco';
2. select * from vendro where (right(telephone),3)=='600' and state= 'California';
3.select distinct state from...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here