100 Days of Sql challenges

Create two databases 'project' and 'myproject' using CREATE DATABASE statement

List all the databases using SHOW DATABASES statement

1. Rename database 'project' to 'mydatabase' using ALTER DATABASE statement
2. Rename database 'mydatabase' back to 'project' again using RENAME DATABASE statement

Verify your changes by listing databases after you run the query

Delete database 'mydatabase' using DROP DATABASE statement

Verify your changes by listing databases after you deleted the database

Select database 'project' using USE DATABASE statement

We can perform operations like creating a TABLE or inserting data to the TABLE only after selecting the database.

Write a query to retrieve all rows from a table

Select specific columns from a table

Add a WHERE clause to filter data based on a condition

Sort the result set in ascending and descending order

Limit the number of rows returned in a query