Files

0x00-python-hello_world
0x01-python-if_else_loops_functions
0x02-python-import_modules
0x03-python-data_structures
0x04-python-more_data_structures
0x05-python-exceptions
0x06-python-classes
0x07-python-test_driven_development
0x08-python-more_classes
0x09-python-everything_is_object
0x0A-python-inheritance
0x0B-python-input_output
0x0C-python-almost_a_circle
0x0D-SQL_introduction
- 0-list_databases.sql
- 1-create_database_if_missing.sql
- 10-top_score.sql
- 100-move_to_utf8.sql
- 101-avg_temperatures.sql
- 102-top_city.sql
- 103-max_state.sql
- 11-best_score.sql
- 12-no_cheating.sql
- 13-change_class.sql
- 14-average.sql
- 15-groups.sql
- 16-no_link.sql
- 2-remove_database.sql
- 3-list_tables.sql
- 4-first_table.sql
- 5-full_table.sql
- 6-list_values.sql
- 7-insert_value.sql
- 8-count_89.sql
- 9-full_creation.sql
- README.md
- temperatures.sql
0x0E-SQL_more_queries
0x0F-python-object_relational_mapping
0x10-python-network_0
0x11-python-network_1
0x12-javascript-warm_up
0x13-javascript_objects_scopes_closures
0x14-javascript-web_scraping
0x15-javascript-web_jquery
.gitignore
README.md

0x0D-SQL_introduction

May 22, 2024

5e080e6 · May 22, 2024

Name	Name	Last commit message	Last commit date
parent directory ..
0-list_databases.sql	0-list_databases.sql	List databases.	May 21, 2024
1-create_database_if_missing.sql	1-create_database_if_missing.sql	Add a script that creates a table called first_table in the current d…	May 21, 2024
10-top_score.sql	10-top_score.sql	Format SQL	May 22, 2024
100-move_to_utf8.sql	100-move_to_utf8.sql	Add a script that converts hbtn_0c_0 database to UTF8 (utf8mb4, colla…	May 21, 2024
101-avg_temperatures.sql	101-avg_temperatures.sql	Add a script that displays the average temperature (Fahrenheit) by ci…	May 22, 2024
102-top_city.sql	102-top_city.sql	Add a script that displays the top 3 of cities temperature during Jul…	May 22, 2024
103-max_state.sql	103-max_state.sql	Add a script that displays the max temperature of each state (ordered…	May 22, 2024
11-best_score.sql	11-best_score.sql	Format SQL	May 22, 2024
12-no_cheating.sql	12-no_cheating.sql	Format SQL	May 22, 2024
13-change_class.sql	13-change_class.sql	Format SQL	May 22, 2024
14-average.sql	14-average.sql	Format SQL	May 22, 2024
15-groups.sql	15-groups.sql	Format SQL	May 22, 2024
16-no_link.sql	16-no_link.sql	Format SQL	May 22, 2024
2-remove_database.sql	2-remove_database.sql	Delete a database if exists.	May 21, 2024
3-list_tables.sql	3-list_tables.sql	List tables.	May 21, 2024
4-first_table.sql	4-first_table.sql	Format SQL	May 22, 2024
5-full_table.sql	5-full_table.sql	Add a script that prints the full description of the table first_tabl…	May 21, 2024
6-list_values.sql	6-list_values.sql	Format SQL	May 22, 2024
7-insert_value.sql	7-insert_value.sql	Format SQL	May 22, 2024
8-count_89.sql	8-count_89.sql	Format SQL	May 22, 2024
9-full_creation.sql	9-full_creation.sql	Format SQL	May 22, 2024
README.md	README.md	Add README.md	May 21, 2024
temperatures.sql	temperatures.sql	Add a script that displays the average temperature (Fahrenheit) by ci…	May 22, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Files

0x0D-SQL_introduction

0x0D-SQL_introduction

README.md

0x0D-SQL_introduction

Files

0x0D-SQL_introduction

Directory actions

More options

Directory actions

More options

Latest commit

History

0x0D-SQL_introduction

Folders and files

parent directory

README.md

0x0D-SQL_introduction