Reference no: EM13930447

1. Using the order_lines table from the database from lecture 2, write the SQL that will give the Min and Max values of the

column "cost_each"

2. Using the week 2 homework database, show each customer number and count the instances of each customer_numb in the

table orders.

Hint: follow this pattern (where the words TABLE and COLUMN are filling in for real names):

SELECT COLUMN, Count(COLUMN)

FROM TABLE

GROUP BY COLUMN;

OR, if you'd like:

SELECT COLUMN, Count(COLUMN) AS [COUNT OF CUSTOMER NUMBERS]

FROM TABLE

GROUP BY COLUMN;

3. Write the SQL to count how many authors have a last name that starts with S.

4. Find the sum of the cost line column

5. How many customers are in each state?

The "answer" is:

SM 4

SO 2

ST 4

SU 4

6. How many books on hand never ordered (the "answer" is 293)

7. Using the week 2 homework database, write the SQL that will show the average of the retail_price column in the books table

8. Write the SQL that will find the sum of the cost_line column in the table order_lines for customers who are in state "ST"

I guess we will need to do an inner join with tables customers and orders and order_lines to get the answer right?

Attachment:- WEEK2_ACCESS2000.zip