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