MySQL
      My Structured Query Language

Lesson 4 SQL Commands & Queries

Table of Art Collection - Exercise 1

art-collection-db.jpg

There are two other tables for category_id and artist_signed_id.

supporting-dbs.jpg

And Artist JOINed with Collection . . .

art-collection-join.jpg

SQL Queries — SELECT

Doing several of the different SELECT queries I got the hang of it. Fairly easy.

4-4-3.gif

Exercise 4(3) I first used the “Print” button then saved as a pdf and changed to gif with Photoshop®.

4-4-4.jpg

Exercise 4(4)

 4-4-5.jpg

Exercise 4(5)

 4-4-6.jpg

Exercise 4(6)
4-4-7.jpg

Exercise 4(7)

 4-4-9.jpg

Exercise 4(9)
4-4-8.gif

Exercise 4(8) Again used the “Print” button as with the first image.