Open the mysql command-line client and connect to our MariaDB database server and the test database.

Select everything from the test01_cass table using the following command:

SELECT * FROM test01_cass;

Select ten rows from the notes_cass table using the following command:

SELECT * FROM notes_cass LIMIT 10; 

Select data with multiple WHERE clauses, an ORDER BY clause, and a LIMIT clause using the following commands:

SELECT * FROM notes_cass 
  WHERE note_note IS NOT NULL 
    AND note_id < 500 
    AND LENGTH(note_note) < 30 
  ORDER BY note_id DESC 
  LIMIT 10; 

Join the notes_cass table in the test database to the publishers table in the isfdb database with some WHERE clauses and a LIMIT clause...