What does $*$ mean in a SELECT statement?

What is the purpose of a JOIN Clause? How many JOIN clauses are there?

What is the difference between a RIGHT JOIN and a LEFT JOIN?

How is the WHERE statement different than the GROUP BY statement?

What is the order that the SQL processor will evaluate SQL statements? How

is this different than how the statement is written?

In the textbook, there are some 'keys' that are discussed. Foreign keys and

primary keys are important. What are these and how are they used in database

design?

Code Questions

From the Hospital Database what SQL code will pull the Doctors Last Name

and their Specialty?

From the Hospital Database what SQL code will pull just the Doctors Unique

ID$?$

Is the Doctor's Unique ID a Key in the Doctors Table? If so$,$ what kind?

The following code is a basic two table join format. You can use this format to

answer the questions that require joins $($below$).$

SELECT column$\_$name$($s$)$

FROM table$1$

LEFT JOIN table $2$

ON table$1.$column$\_$name $=$ table$2.$column$\_$name;

Describe the steps that are occurring based on the lecture slide that deals with

SQL processor operations. What is happening in the processor first? What is

happening in the processor second? What is happening in the processor third?

What SQL code would JOIN admissions table information with patient

information?

If you were to modify that SQL code to provide just patient last name and

diagnosis what code would provide only those two fields in the SQL viewer?

If you were to modify that SQL code to provide last name, diagnosis, and

birth date, what code would provide only those three fields?

For $11$ and $12($above$),$ how many fields are present if the ${?}^{**}$ is used in the

SELECT statement?

For $11$ and $12($above$),$ how many records are present when the JOIN is

implemented?

In the Northwind Database, category$\_$id $($from categories$)$ is related to the

products table. First, look at the schematic and explain how its related based on

the chapter readings. Second, what code would JOIN these two tables?

How would you view Category Name and the Supplier ID in the SQL

viewer?