Question: Use the following SQL code to answer the following: Write an SQL statement to view: title and quantity of the books written by authorID =

Use the following SQL code to answer the following:

  • Write an SQL statement to view: title and quantity of the books written by authorID = 1.
  • Write an SQL statement to view all the information in table customers.

Write an SQL statement to view: cName, and ResDate.

  • Write an SQL statement to view: cname, resdate, and destination in the year 2020.

Step by Step Solution

★★★★★

3.53 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Here are SQL statements to achieve the requested views 1 To view the title and qu... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in...

Q:

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Q:

In the last chapter you added and modified some tables for Kelly's Boutique. She would now like you to create, run, and print some select, parameter, and action queries. Make the following changes...

Q:

This uses microsoft SQL management Studio I. OBJECTIVES At the end of this activity, the students will be able to: 1. Create, Alter, and Drop SQL VIEWs. 2. Understand the use of WITH SCHEMABINDING....

Q:

**PART-2 MySQL Database Scripting (40%, 80 points)** When connected to your MySQL , open a new SQL tab. Write a complete script to create a new database (also called 'schema' in MySQL ) Bookstore ....

Q:

Before starting these problems, update the JustLee Books database by executing the JLDB _ Build _ 9 . sql script, otherwise, your solutions might not work! Note: In this module, it is assumed that...

Q:

What is the purpose of the AS clause in SQL? It defines a search condition It assigns aliases to tables, columns, or calculations It is used in INNER JOIN to join two tables Neither of the other...

Q:

Homework07 SQL Joins- You must use a JOIN for each of the following queries. In this assignment you will be asked to create several SQL queries relating to the Sakila database that we installed in...

Q:

/* You are to develop SQL statements for each task listed. You should type your SQL statements under each task. You should always create an alias for any derived fields. Add a sort that makes sense...

Q:

--* BUSIT 103 Assignment #3 DUE DATE : Consult course calendar /* You are to develop SQL statements for each task listed. You should type your SQL statements under each task. You should always create...

Q:

Facts: Parent Co paid $264,000 for 80% of the outstanding voting stock of Sub Co on January 1, Year 1, when Sub Co s stockholders equity consisted of $180,000 common stock and $90,000 retained...

Q:

Recruits for a police academy were required to undergo a test that measures their exercise capacity. The exercise capacity (in minutes) was obtained for each of 20 recruits: a. Draw a dotplot of the...

Q:

For what period of time must a broker retain the brokerage relationship disclosure documents that result in a written contract?

Q:

Assume the same information as in IFRS11-11, except that Pujols intends to dispose of the equipment in the coming year. Instructions (a) Prepare the journal entry (if any) to record the impairment of...

Q:

Briefly describe some of the similarities and differences between U.S. GAAP and iGAAP with respect to income tax accounting.

Q:

Describe the procedure(s) involved in classifying deferred tax amounts on the statement of financial position under IFRS.

Q:

For each of the following transactions, indicate which company should include the inventory on its December 31, 2010, balance sheet: 1. Michelson Supplies Inc. shipped merchandise to PJ Sales on...

Q:

As the proprietor of Kingston Tires, Inc., you received the following invoice from a supplier: Requirements 1. Journalize the transaction required on September 23, 2012. 2. Journalize the return on...

Q:

The Project: A paratrooper and parachute weigh 200 lb. At the instant the parachuteopens, he is traveling vertically downward at 40 ft/sec. If the air resistance variesdirectly as the instantaneous...

Q:

Many queries search by the number of days to ship (number of days between the order and shipping dates). Create an index that might improve the performance of these queries.

Q:

What functions can be used to search character strings for specific patterns of data?

Q:

Create a new table containing the category code and description for the categories of books sold by JustLee Books. The table should be called CATEGORY, and the columns should be CatCode and CatDesc....

Q:

=+a. Calculate the sample correlation coefficient for the nine (x, y) pairs.

Q:

=+b. The second observation has a very extreme y value (in the full data set consisting of 72 observations, there were 2 of these). This observation may have had a substantial impact on the form of...

Q:

=+analysis. Here is representative data: x: 50 71 55 50 33 58 79 y: 152 1929 48 22 2 5 35 x: 26 69 44 37 70 20 45 49 y: 7 269 38 171 13 43 185 25