Devam Ediyor

501380 SQL code

1. Using the BOOKS table, write a query that will list the categories for the books in inventory. List each category only once in your result set.

2. Using the BOOKS table, write a query that will list the title and publisher ID for each book in the table. Use the column heading of "Publisher ID" for the pubid field.

3. Using the BOOKS table, write a query that will list the book title, retail price, and the amount of markup for each book. The amount of markup is the retail price minus the cost. Use the column heading “Price Markup” for the arithmetic expression column.

4. Using the BOOK_CUSTOMER table, write a query that will list the customer's first name, last name, and city for those customers living in zip code 31206.

5. Using the BOOK_ORDER table, write a query that will list everything about the orders placed prior to April 2, 2009.

6. Using the BOOK_ORDER table, write a query that will list everything about the orders that have not been shipped yet.

7. Using the BOOK_CUSTOMER table, write a query using the AND and OR operators that will list the customer information for those customers living in either Florida or New Jersey who have not been referred by another customer.

8. Using the BOOKS table, write a query that will list all information about those books that are not computer books and do not cost more than $30.00 retail.

9. Using the AUTHOR table, write a query that will list all information about authors whose first name ends with an “A”. Put the results in descending order of last name, and then ascending order by first name. This should be done using a single query.

10. Using the BOOK_ORDER table, write a query using the > and < operators that will list the orders that were placed between April 1, 2009 and April 4, 2009. Only show the orders for April 2nd and 3rd in your result set.

11. Using the BOOK_ORDER table, write a query that will list the orders that were placed between April 2, 2009 and April 4, 2009 including those placed on the 2nd and 4th. Use a different approach (operator) in writing this query than used in the query for #10, that is, do not use > and < signs in your query.

12. Using the BOOKS table, write a query that will list the book title, publisher ID, and published date for all books that were published by publisher 4 or after January 1, 2001. Order the results in ascending order by publisher ID and give the publish date and publisher ID columns meaningful titles.

13. Many organizations use percentage of markup (e.g., profit margin) when analyzing financial data. To determine the percentage of markup for a particular item, simply subtract the cost for the item from the retail price to obtain the dollar amount of profit, and then divide the profit by the cost of the item. The resulting solution is then multiplied by 100 to determine the percent of markup. Using a SELECT statement, display the title of each book and its percent of markup. For the column displaying the percent of markup, use “Markup %” as the column heading.

Beceriler: Her şey Kabul, Makale Yeniden Yazım, SQL

Daha fazlasını görün: writing in code, writing computer code, writing book titles, write an article on computer, when writing a book title, sql price, operator code, list of books by author, id to code, first code, everything 5 dollar, dollar everything, code writing code, code writing, code 8, book titles in writing, books by author, books and authors, authors of the books, article for city writing, article different author, 5 dollar everything, list of book and authors, Sql code, select item from

İşveren Hakkında:
( 3 değerlendirme )

Proje NO: #2247301

Seçilen:

Baxter2008

Hello Sweetiepie I am Expertrating-certified in Sql and can deliver your project within 24 hours.

1 gün içinde 15$ USD
(21 Değerlendirme)
3.2