Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer only 10,12,13 code is sa 6 List the book code and han $20.00 Wone type FIC, MYS, or ART. For the first tive

Please answer only 10,12,13 image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
code is sa 6 List the book code and han $20.00 Wone type FIC, MYS, or ART. For the first tive books in the BOOK Uuse the PRICE column to calculate the disc publisher each publisher containing the word and & Find the name of 9 List the book code and title of each book that has the type FIC, MYS USA, list the book code and title. ook kir How many books have the type SFI? 1 Calculate the average price for books that have the type ART number 3 12 For each book published by Penguin 3 List the book code, book title, and units on hand for each book in branch Alexamara Marina Group Answer each of Fover each of the following questions using the Alexamara Marina G 1-8 through 1-12. No computer work is required List the owner number, last name, and first name of every boat owner 2 List the last name and first name of every owner located in Bowton. 3 List the marina number and slip number for every slip whose length is equal to a 30 feet 4List the marina number a 5. List the slip number for every boat with the nd slip number for every boat with the type Dolphin 26 type Dolphin 28 that is located in m List the boat name for each boat located in a slip whose length is between 25 7. List the sip number for every slip in marina 1 whose annual rental fee is less t $3,000.00. 8. Labor is billed at the rate of $60.00 per hour. List the slip ID, category numbe hours, and estimated labor cost for every service request. To obtain the estimat multply the estimated hours by 60. Use the column name ESTIMATED COS mated labor cost. List the marina number and slip number for all slips containing a boat wit 4000, Sprite 3000, or Ray 4025. 9. 0, How many Dolphin 25 boats are stored at both marinas? Chapter 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Management Systems

Authors: Patricia Ward, George A Dafoulas

1st Edition

1844804526, 978-1844804528

More Books

Students also viewed these Databases questions

Question

3. Do you have any digital marketing experience?

Answered: 1 week ago

Question

13. You always should try to make a good first impression.

Answered: 1 week ago