Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

SQL

memorize.ai (lvl 286)

(0)

20 cards

()

Section 1

Preview this deck

Determine how many orders have been placed by each customer. Do not include in the results any customer who hasn't recently placed an order with JustLee books.

Front

1 / 20

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (20)

Section 1

(20 cards)

Determine how many orders have been placed by each customer. Do not include in the results any customer who hasn't recently placed an order with JustLee books.

Front

.

Back

Determine the average retail price of books by publisher name and category. Include only the categories children and Computer and the groups with an average retail price greater than $50.

Front

.

Back

List the retail price of the least expensive book in the computer category

Front

.

Back

Create an alphabetical list of all criminals, including criminal ID, name, violent offender status, parole status, and any known aliases.

Front

.

Back

Display the customer who has the last name Cruz. Write a query that will allow a user to write the name in lowercase.X

Front

.X

Back

Using either the WHERE clause or JOIN techniques, List all criminals along with the crime charges filed. The report needs to include the criminal ID, Name, Crime, and fine amount. This query will require that you join criminals, crimes, and crime charges tables

Front

.

Back

Display a list of all book titles and the percentage of markup for each book. The percentage of markup should be displayed as a whole number (that is, multiplied by 100) with no decimal position, followed by a percent sign (for example, .2793 = 28%). (the percentage of markup percentage of markup should reflect the difference between the retail and cost amounts as a percent of the cost.)

Front

.

Back

Display a list of all book titles and the percentage of markup for each book. The percentage of markup should be displayed as a whole number (that is, multiplied by 100) with no decimal position, followed by a percent sign (for example, .2793 = 28%). (the percentage of markup percentage of markup should reflect the difference between the retail and cost amounts as a percent of the cost.)

Front

.X

Back

Produce a list of all customer names in which the first letter of first and last name is in uppercase and the rest are in lowercase.

Front

.XX

Back

List the following information for all crimes that have a period greater than 14 days between the date charged and the hearing date: crime ID, classification, date charged, hearing date, and the number of days between the date charged and the hearing date.

Front

.X

Back

Non-equality Join: What gift will a customer who orders the book Shortest Poems receive? Use the actual book retail value to determine the gift.

Front

.

Back

Determine how many books are in the Cooking category

Front

.

Back

List books written by author's last name. Complete using both the where clause and the From clause. tables needed include books, bookauthor, and author.

Front

.

Back

Produce a list of all customers that live in Florida and have ordered books about computers

Front

.

Back

Determine which books customer Jake Lucas has purchased. Perform the search using the customer name, not the customer number. If he has purchased multiple copies of the same book, unduplicate the results.

Front

.

Back

Display the most recent publication date of all books sold by JustLee Books

Front

.

Back

Narrow the same query down to books written by an author with the last name Adams. Perform the search using the author name. Complete using both the where clause and the From clause.

Front

.

Back

Determine which orders haven't shipped and the name of the customer who placed the order. Sort results by the date on which the order was placed.

Front

.

Back

List all criminals along with crime information. The report needs to include the criminal ID, name, crime classification, date charged, crime code, and fine amount. Include only crimes classified as "Other". Sort the list by criminal ID, and date charged.

Front

.

Back

List all criminals along with crime status and appeal status (if applicable). The reports need to include the criminal ID, name, crime classification, date charged, appeal filing date, and appeal status. Show all criminals, regardless of whether they have filed an appeal

Front

.

Back