0x0D-SQL_introduction

SQL - Introduction

• A projects done during my Full Stack Software Engineering studies at ALX Africa, a course offered by Holberton School.

Technologies

• Files written in vi, vim, and emacs editors.
• SQL files executed on Ubuntu 20.04 LTS using MySQL 8.0 (version 8.0.25)

Directories

File	Question
0-list_databases.sql	Write a script that lists all databases of your MySQL server.
1-create_database_if_missing.sql	Write a script that creates the database hbtn_0c_0 in your MySQL server. If the database hbtn_0c_0 already exists, your script should not fail.
2-remove_database.sql	Write a script that deletes the database hbtn_0c_0 in your MySQL server. If the database hbtn_0c_0 doesn’t exist, your script should not fail.
3-list_tables.sql	Write a script that lists all the tables of a database in your MySQL server.
4-first_table.sql	Write a script that creates a table called first_table in the current database in your MySQL server.
5-full_table.sql	Write a script that prints the full description of the table first_table from the database hbtn_0c_0 in your MySQL server.
6-list_values.sql	Write a script that lists all rows of the table first_table from the database hbtn_0c_0 in your MySQL server.
7-insert_value.sql	Write a script that inserts a new row in the table first_table (database hbtn_0c_0) in your MySQL server.
8-count_89.sql	Write a script that displays the number of records with id = 89 in the table first_table of the database hbtn_0c_0 in your MySQL server.
9-full_creation.sql	Write a script that creates a table second_table in the database hbtn_0c_0 in your MySQL server and add multiples rows.
10-top_score.sql	Write a script that lists all records of the table second_table of the database hbtn_0c_0 in your MySQL server.
11-best_score.sql	Write a script that lists all records with a score >= 10 in the table second_table of the database hbtn_0c_0 in your MySQL server.
12-no_cheating.sql	Write a script that updates the score of Bob to 10 in the table second_table.
13-change_class.sql	Write a script that removes all records with a score <= 5 in the table second_table of the database hbtn_0c_0 in your MySQL server.
14-average.sql	Write a script that computes the score average of all records in the table second_table of the database hbtn_0c_0 in your MySQL server.
15-groups.sql	Write a script that lists the number of records with the same score in the table second_table of the database hbtn_0c_0 in your MySQL server.
16-no_link.sql	Write a script that lists all records of the table second_table of the database hbtn_0c_0 in your MySQL server.
100-move_to_utf8.sql	Write a script that converts hbtn_0c_0 database to UTF8 (utf8mb4, collate utf8mb4_unicode_ci) in your MySQL server.
101-avg_temperatures.sql	Import in hbtn_0c_0 database this table dump. Write a script that displays the average temperature (Fahrenheit) by city ordered by temperature (descending).
102-top_city.sql	Import in hbtn_0c_0 database this table dump. Write a script that displays the top 3 of cities temperature during July and August ordered by temperature (descending).
103-max_state.sql	Import in hbtn_0c_0 database this table dump. Write a script that displays the max temperature of each state (ordered by State name).