Unit 15, SQL

Get Started

Clone this repository on your local machine.

Struсture

The repository contains a folder "tables" where all queries and answers for 4 tables are located: concept, concept_ancestor, concept_relationship, and concept_synonym.

Code style

Each index.sql file contains both queries and answers to questions.

Take note #1: All statements and functions are written in uppercase. Reductions like concept_relationship c were avoided for more clear understanding so you can find AS statement that was used for it.

Take note #2: The detailed answer to the question is used as a comment and has the next structure: /* === My answer... === /. Questions are enclosed in a regular comment: / Question... */

Take note #3: Answers for last question where comparison between concept_ancestor and concept_relationship is describen are located in folder for concept_relationship after all queries.