SQL Basics

Let your classmates do this without any help. Will you discuss this with classmates when you're done?

• Yes

• No

After logging into a mySQL database, what command would give this output?

(a)  

After logging into a mySQL database, what command would let you select the employees database?

(a)  

Using only one keyword (two words total), what command/query will produce the following explanation of the employees table?

(a)  

Let's examine this screenshot. What database are we on?

• employees

• bios_sample

• training

• stock_portfolio_cost

• None of these

Now we're on the training database. What does the select query return?

Type one word as the answer, in all lower case.

Given the first two tables, which type of join will result in the last table?

(a)  

Type one word as the answer, in all lower case.

Given the first two tables, which type of join will result in the last table?

(a)  

The following query will return a maximum of how many rows?

SELECT borough, (ela + history + foreign_lang)/3.0 FROM all_student_info, all_student_grades_v1;

• 1107

• 750

• 1107*750

• 1107+750

• error

The following query will return a maximum of how many rows?

SELECT borough, (ela + history + foreign_lang)/3.0 FROM all_student_info info, all_student_grades_v1 grades WHERE info.student_id = grades.student_id;

• 1107

• 750

• 1107*750

• 1107+750

• error