Use bottom three pcitures for data requied. First three pictues have questions o

Question

Use bottom three pcitures for data requied. First three pictues have questions on them.

Question 1

Henry Books Database: Problem 18 (p.126)

        

QUESTION 2

         Premiere Products Database: Problem 3 (p.125)

        

QUESTION 3

         Alexamara Marina Group Database: Problem 7 (p.127)

QUESTION 4

         Premiere Products Database: Problem 14 (p.125)

        

QUESTION 5

         Henry Books Database: Problem 7 (p.126)

        

QUESTION 6

         Alexamara Marina Group Database: Problem 4 (p.127)

        

QUESTION 7

         Premiere Products Database: Problem 17 (p.125)

        

QUESTION 8

         Henry Books Database: Problem 21 (p.126)

        

QUESTION 9

         Premiere Products Database: Problem 1 (p.125)

        

QUESTION 10

         Premiere Products Database: Problem 12 (p.125)

        

QUESTION 11

         Alexamara Marina Group Database: Problem 1 (p.127)

        

QUESTION 12

         Premiere Products Database: Problem 9 (p.125)

        

QUESTION 13

         Premiere Products Database: Problem 13 (p.125)

        

QUESTION 14

         Alexamara Marina Group Database: Problem 8 (p.127)

        

QUESTION 15

         Henry Books Database: Problem 8 (p.126)

        

QUESTION 16

         Henry Books Database: Problem 12 (p.126)

        

QUESTION 17

         Henry Books Database: Problem 16 (p.126)

        

QUESTION 18

         Henry Books Database: Problem 9 (p.126)

        

QUESTION 19

         Premiere Products Database: Problem 15 (p.125)

        

QUESTION 20

         Henry Books Database: Problem 10 (p.126)

        

arina Group database (Figures 1-8 through 1-12 in Chapter 1) Alexamara Marina Gro nd the lexaas. Use the notes at the end of Chapter 3 to print your output if saL My Use w let to do so by your instructor r number, last name, and first name of every boat owner te MARINA table (all rows and all columns). t le 127 2 List the complete me and first name of every owner located in Bowton. the last name and first name of every owner not located in Bowt on number and slip number for every slip whose length is equal to or less than List the marina 30 feet List the marina a 5. number and slip number for every boat with the type Dolphin 28. the slip number for every boat with the type Dolphin 28 that is located in marina 1. List t name for each boat located in a slip whose length is between 25 and 30 feet. List the boa the slip number for every slip in marina 1 whose rental fee is less than $3,000. List Labor is billed at the rate of $60 per hour. List the slip ID, category number, estimated hours, and estimated labor cost for every service request. To obtain the estimated labor cost, mul- tiply the estimated hours by 60. Use the column name ESTIMATED_COST for the esti- mated labor cost. 10. 1. List the marina number and slip number for all slips containing a boat with the type Sprite 12 List the marina number, slip number, and boat name for all boats. Sort the results by boat 13. How many Dolphin 28 boats are stored at both marinas? 4000, Sprite 3000, or Ray 4025 name within marina number. 14. Calculate the total rental fees Alexamara receives each year based on the length of the slip.

Explanation / Answer

Question 1 Henry Books Database: Problem 18 (p.126)

select Type, average(Price) from book;

QUESTION 2 Premiere Products Database: Problem 3 (p.125)

select customer_name from customer where credit_limit <= 7500;

QUESTION 3 Alexamara Marina Group Database: Problem 7 (p.127)

select Slip_number from Boat where Type = 'Dolphin 28' and Location = 'marina 1';

QUESTION 4 Premiere Products Database: Problem 14 (p.125)

select count(*) from customer where balance > credit_limit;

QUESTION 7 Premiere Products Database: Problem 17 (p.125)

select max(Price) from Part;

QUESTION 9 Premiere Products Database: Problem 1 (p.125)

select Part_number, Description, Price from Part;

QUESTION 10 Premiere Products Database: Problem 12 (p.125)

select * from Part order by Description;

QUESTION 12 Premiere Products Database: Problem 9 (p.125)

select Part_num, Description, (on_hand * Price) as On_Hand_Value from part where On_Hand_Value <= 7500;

QUESTION 13 Premiere Products Database: Problem 13 (p.125)

select * from Part order by Class, Part_num;

QUESTION 19 Premiere Products Database: Problem 15 (p.125)

select sum(balance) from Customer where balance < Credit_limit and Rep_num = 65;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.