Here's a query:
SELECT orders.order_date, orders.customer_numb
FROM orders INNER JOIN order_lines ON orders.order_numb = order_lines.order_numb
WHERE order_lines.isbn = '0-131-4966-9';
and here it is rewritten using a subquery:
SELECT order_date, customer_numb
Write SELECT statements for the following questions. Make sure to include the statement execution, including the resulting data.
Display all columns and all rows from the Employees table.
9 rows returned
Display the regionid, regiondescription for all rows in the Regions table.
4 rows returned
Modify query 2 so that the
Start Access, and then open the FirmPays database. Open the query named " June 2". View the query in SQL and answer the following questions. Explain your answers.
Which tables are used in the query?
Which fields are displayed in the query results?
What type of join is used between the tables?
What selection criter
Create a query with the kudler_team_c database I attached.
This query should pull at least two tables together. So it needs to have the following:
You can decide what tables to put together and what fields to pull out.
The schema of the DB is as follows:
Department(DeptNum, Descrip, Instname, DeptName, State, Postcode)
Academic(AcNum, *DeptNum, FamName, GiveName, Initials, Title)
Field(FieldNum, ID, Title)
Interest(*FieldNum, *AcNum, Descrip)
Which fields have interests share
2. Write a query, based on data dictionary views, reporting a table's name, number of rows, average row length, column name (in order they appear in the table), the average column length, and the high and low values found in each column (the values are in hexadecimal format). When you are logged on as CLASSMATE, run the query. T
How come I get so many Smiths in this query (using the Week 2 lecture database)? There's only 26 orders and 4 customers named Smith. Yet I get 104 rows as a result?
SELECT orders.order_numb, customers.customer_last_name
FROM orders, customers
WHERE customers.customer_last_name like "smith";
1. Discuss what SQL is and its importance.
2. Name and describe the SQL statements used for data modification.
3. Compare the join and the SQL subquery.
4. Name and briefly describe the five SQL built-in functions.
5. Write the SELECT statement to display all the columns of the STUDENT table but only those rows