SQL Tutorial 2 : Additional criterias with the use of OR/IN/AND Functions

In reality, the dataset that we want to obtain often requires the application of much more criterias and filters than just 1. Building on what we explored in Topic 1, we will use new functions such as the “AND/OR/IN” functions to build on our “SELECT FROM WHERE” framework. “OR” Function Referring to the same ”world_data” … Continue reading SQL Tutorial 2 : Additional criterias with the use of OR/IN/AND Functions

SQL Tutorial 1 : “SELECT FROM WHERE” Framework

“SELECT FROM WHERE”  The key framework governing SQL are these 3 keywords : “SELECT”, “FROM”,  “WHERE”. Firstly, for SELECT, we are choosing which columns in the database that we want to extract data from. Secondly, for FROM, we are choosing which table in the database to extract data from. This is crucial because a database … Continue reading SQL Tutorial 1 : “SELECT FROM WHERE” Framework