Quiz: SQL Joins
- Due Nov 22, 2013 at 11:59pm
- Points 10
- Questions 5
- Available until Nov 23, 2013 at 12:05am
- Time Limit None
- Allowed Attempts 2
Instructions
Consider the following two tables:
mysql> SELECT * mysql> SELECT * -> FROM uppercase; -> FROM lowercase; +----+----+ +----+----+ | id | up | | id | lo | +----+----+ +----+----+ | 1 | A | | 2 | b | | 2 | B | | 3 | c | | 3 | C | | 4 | d | | 4 | D | | 5 | e | +----+----+ +----+----+
Use the following command to load the above tables from the mysql>
prompt:
source /home/public/cs212/sql/letters.sql
Use may also copy/paste the following SQL to create the tables:
CREATE TABLE uppercase ( id INTEGER NOT NULL PRIMARY KEY, up CHAR(1) NOT NULL ); CREATE TABLE lowercase ( id INTEGER NOT NULL PRIMARY KEY, lo CHAR(1) NOT NULL );
Only registered, enrolled users can take graded quizzes