{"isTableOfContentPresent":true,"courseSlug":"learn-sql","chapters":{"110-getting-started":{"chapterName":"Getting Started","pages":[{"file":"110-working-internet.md","title":"

All you need is a working internet connection

","slug":"all-you-need-is-a-working-internet-connection","is_not_exercise":true,"label":"1.1","pagePath":"/learn-sql/pages/all-you-need-is-a-working-internet-connection","pageName":"

All you need is a working internet connection

"},{"file":"120-help.md","title":"

Let us know what you think of BigBinary Academy

","slug":"let-us-know-what-you-think-of-bigbinary-academy","is_not_exercise":true,"label":"1.2","pagePath":"/learn-sql/pages/let-us-know-what-you-think-of-bigbinary-academy","pageName":"

Let us know what you think of BigBinary Academy

"},{"file":"130-next-previous-using-keyboard.md","title":"

Next & Previous page using keyboard

","slug":"next-previous-page-using-keyboard","is_not_exercise":true,"label":"1.3","pagePath":"/learn-sql/pages/next-previous-page-using-keyboard","pageName":"

Next & Previous page using keyboard

"},{"file":"140-running-code-using-keyboard.md","title":"

Running code using keyboard

","slug":"running-code-using-keyboard","is_not_exercise":true,"label":"1.4","pagePath":"/learn-sql/pages/running-code-using-keyboard","pageName":"

Running code using keyboard

"}]},"120-select":{"chapterName":"Select","pages":[{"file":"110-select-all.md","title":"

SELECT *

","slug":"select-all","is_not_exercise":true,"label":"2.1","pagePath":"/learn-sql/pages/select-all","pageName":"

SELECT *

"},{"file":"120-select-all-ex1.md","title":"

Exercise - Select *

","slug":"exercise-select-all","is_not_exercise":false,"label":"2.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-all","pageName":"

Exercise - Select *

"}]},"130-select-and-filter":{"chapterName":"Select and filter","pages":[{"file":"110-select-where-equal-to.md","title":"

Select all Python students

","slug":"select-all-python-students","is_not_exercise":true,"label":"3.1","pagePath":"/learn-sql/pages/select-all-python-students","pageName":"

Select all Python students

"},{"file":"120-select-where-equal-to-ex1.md","title":"

Exercise - Find all students who are enrolled in JavaScript course

","slug":"exercise-find-all-students-enrolled-in-javascript-course","is_not_exercise":false,"label":"3.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-find-all-students-enrolled-in-javascript-course","pageName":"

Exercise - Find all students who are enrolled in JavaScript course

"},{"file":"130-select-where-equal-to-ex2.md","title":"

Exercise - Find all students of age 12

","slug":"exercise-find-all-students-of-age-12","is_not_exercise":false,"label":"3.1 - Ex 2","pagePath":"/learn-sql/pages/exercise-find-all-students-of-age-12","pageName":"

Exercise - Find all students of age 12

"},{"file":"140-select-where-not-equal-to.md","title":"

Select where not equal to

","slug":"select-where-not-equal-to","is_not_exercise":true,"label":"3.2","pagePath":"/learn-sql/pages/select-where-not-equal-to","pageName":"

Select where not equal to

"},{"file":"150-select-where-not-equal-to-ex1.md","title":"

Exercise - Select where not equal to

","slug":"exercise-select-where-not-equal-to","is_not_exercise":false,"label":"3.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-not-equal-to","pageName":"

Exercise - Select where not equal to

"}]},"140-less-than-greater-than":{"chapterName":"Less than and greater than","pages":[{"file":"110-select-where-less-than.md","title":"

Select where less than

","slug":"select-where-less-than","is_not_exercise":true,"label":"4.1","pagePath":"/learn-sql/pages/select-where-less-than","pageName":"

Select where less than

"},{"file":"120-select-where-less-than-ex1.md","title":"

Exercise - Select where less than

","slug":"exercise-select-where-less-than","is_not_exercise":false,"label":"4.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-less-than","pageName":"

Exercise - Select where less than

"},{"file":"130-select-where-greater-than.md","title":"

Select where greater than

","slug":"select-where-greater-than","is_not_exercise":true,"label":"4.2","pagePath":"/learn-sql/pages/select-where-greater-than","pageName":"

Select where greater than

"},{"file":"140-select-where-greater-than-ex1.md","title":"

Exercise - Select where greater than

","slug":"exercise-select-where-greater-than","is_not_exercise":false,"label":"4.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-greater-than","pageName":"

Exercise - Select where greater than

"}]},"150-less-than-greater-than-with-equal-to":{"chapterName":"Less than and greater than with equal to","pages":[{"file":"110-select-where-less-than-or-equal-to.md","title":"

Select where less than or equal to

","slug":"select-where-less-than-or-equal-to","is_not_exercise":true,"label":"5.1","pagePath":"/learn-sql/pages/select-where-less-than-or-equal-to","pageName":"

Select where less than or equal to

"},{"file":"120-select-where-less-than-or-equal-to-ex1.md","title":"

Exercise - Select where less than or equal to

","slug":"exercise-select-where-less-than-or-equal-to","is_not_exercise":false,"label":"5.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-less-than-or-equal-to","pageName":"

Exercise - Select where less than or equal to

"},{"file":"130-select-where-greater-than-or-equal-to.md","title":"

Select where greater than or equal to

","slug":"select-where-greater-than-or-equal-to","is_not_exercise":true,"label":"5.2","pagePath":"/learn-sql/pages/select-where-greater-than-or-equal-to","pageName":"

Select where greater than or equal to

"},{"file":"140-select-where-greater-than-or-equal-to-ex1.md","title":"

Exercise - Select where greater than or equal to

","slug":"exercise-select-where-greater-than-or-equal-to","is_not_exercise":false,"label":"5.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-greater-than-or-equal-to","pageName":"

Exercise - Select where greater than or equal to

"}]},"155-comments":{"chapterName":"Comments","pages":[{"file":"110-sql-comments.md","title":"

SQL comments

","slug":"sql-comments","is_not_exercise":true,"label":"6.1","pagePath":"/learn-sql/pages/sql-comments","pageName":"

SQL comments

"},{"file":"120-sql-comments-ex1.md","title":"

Exercise - SQL comments

","slug":"exercise-sql-comments","is_not_exercise":false,"label":"6.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-sql-comments","pageName":"

Exercise - SQL comments

"},{"file":"130-sql-multiline-comments.md","title":"

SQL multiline comments

","slug":"sql-multiline-comments","is_not_exercise":true,"label":"6.2","pagePath":"/learn-sql/pages/sql-multiline-comments","pageName":"

SQL multiline comments

"},{"file":"140-sql-multiline-comments-ex1.md","title":"

Exercise - SQL multiline comments

","slug":"exercise-sql-multiline-comments","is_not_exercise":false,"label":"6.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-sql-multiline-comments","pageName":"

Exercise - SQL multiline comments

"}]},"160-and-or-operator":{"chapterName":"AND & OR","pages":[{"file":"110-select-where-and.md","title":"

Select using AND condition

","slug":"select-using-and-condition","is_not_exercise":true,"label":"7.1","pagePath":"/learn-sql/pages/select-using-and-condition","pageName":"

Select using AND condition

"},{"file":"120-select-where-and-ex1.md","title":"

Exercise - Select using AND condition

","slug":"exercise-select-using-and-condition","is_not_exercise":false,"label":"7.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-using-and-condition","pageName":"

Exercise - Select using AND condition

"},{"file":"130-select-where-or.md","title":"

Select using OR condition

","slug":"select-where-and-or","is_not_exercise":true,"label":"7.2","pagePath":"/learn-sql/pages/select-where-and-or","pageName":"

Select using OR condition

"},{"file":"140-select-where-or-ex1.md","title":"

Exercise - Select using OR condition

","slug":"exercise-select-using-or-condition","is_not_exercise":false,"label":"7.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-using-or-condition","pageName":"

Exercise - Select using OR condition

"},{"file":"150-select-where-combined-conditions.md","title":"

Select using both AND and OR

","slug":"select-using-both-and-and-or","is_not_exercise":true,"label":"7.3","pagePath":"/learn-sql/pages/select-using-both-and-and-or","pageName":"

Select using both AND and OR

"},{"file":"160-select-where-combined-conditions-ex1.md","title":"

Exercise - Select where AND and OR

","slug":"exercise-select-where-and-and-or","is_not_exercise":false,"label":"7.3 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-and-and-or","pageName":"

Exercise - Select where AND and OR

"}]},"170-between-and-not-between-operator":{"chapterName":"BETWEEN & NOT BETWEEN","pages":[{"file":"110-select-where-between.md","title":"

Select using BETWEEN

","slug":"select-where-between","is_not_exercise":true,"label":"8.1","pagePath":"/learn-sql/pages/select-where-between","pageName":"

Select using BETWEEN

"},{"file":"120-select-where-between-ex1.md","title":"

Exercise - Select using BETWEEN

","slug":"exercise-select-where-between","is_not_exercise":false,"label":"8.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-between","pageName":"

Exercise - Select using BETWEEN

"},{"file":"130-select-where-between-and-other-conditions.md","title":"

Select using BETWEEN and other conditions

","slug":"select-where-between-and-other-conditions","is_not_exercise":true,"label":"8.2","pagePath":"/learn-sql/pages/select-where-between-and-other-conditions","pageName":"

Select using BETWEEN and other conditions

"},{"file":"140-select-where-between-and-other-conditions-ex1.md","title":"

Exercise - Select using BETWEEN and other conditions

","slug":"exercise-select-where-between-and-other-conditions","is_not_exercise":false,"label":"8.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-between-and-other-conditions","pageName":"

Exercise - Select using BETWEEN and other conditions

"},{"file":"150-select-where-not-between.md","title":"

Select using NOT BETWEEN

","slug":"select-where-not-between","is_not_exercise":true,"label":"8.3","pagePath":"/learn-sql/pages/select-where-not-between","pageName":"

Select using NOT BETWEEN

"},{"file":"160-select-where-not-between-ex1.md","title":"

Exercise - Select using NOT BETWEEN

","slug":"exercise-select-where-not-between","is_not_exercise":false,"label":"8.3 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-not-between","pageName":"

Exercise - Select using NOT BETWEEN

"}]},"180-in-and-not-in-operator":{"chapterName":"IN & NOT IN","pages":[{"file":"110-select-where-in.md","title":"

Select using IN

","slug":"select-where-in","is_not_exercise":true,"label":"9.1","pagePath":"/learn-sql/pages/select-where-in","pageName":"

Select using IN

"},{"file":"120-select-where-in-ex1.md","title":"

Exercise - Select using IN

","slug":"exercise-select-where-in","is_not_exercise":false,"label":"9.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-in","pageName":"

Exercise - Select using IN

"},{"file":"130-select-where-not-in.md","title":"

Select using NOT IN

","slug":"select-where-not-in","is_not_exercise":true,"label":"9.2","pagePath":"/learn-sql/pages/select-where-not-in","pageName":"

Select using NOT IN

"},{"file":"140-select-where-not-in-ex1.md","title":"

Exercise - Select using NOT IN

","slug":"exercise-select-where-not-in","is_not_exercise":false,"label":"9.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-not-in","pageName":"

Exercise - Select using NOT IN

"}]},"190-null-operator":{"chapterName":"NULL value","pages":[{"file":"110-what-is-null.md","title":"

What is null

","slug":"what-is-null","is_not_exercise":true,"label":"10.1","pagePath":"/learn-sql/pages/what-is-null","pageName":"

What is null

"},{"file":"120-select-where-null.md","title":"

Select where NULL

","slug":"select-where-null","is_not_exercise":true,"label":"10.2","pagePath":"/learn-sql/pages/select-where-null","pageName":"

Select where NULL

"},{"file":"130-select-where-null-ex1.md","title":"

Exercise - Select where NULL

","slug":"exercise-select-where-null","is_not_exercise":false,"label":"10.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-null","pageName":"

Exercise - Select where NULL

"},{"file":"140-select-where-not-null.md","title":"

Select where NOT NULL

","slug":"select-where-not-null","is_not_exercise":true,"label":"10.3","pagePath":"/learn-sql/pages/select-where-not-null","pageName":"

Select where NOT NULL

"},{"file":"150-select-where-not-null-ex1.md","title":"

Exercise - Select where NOT NULL

","slug":"exercise-select-where-not-null","is_not_exercise":false,"label":"10.3 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-not-null","pageName":"

Exercise - Select where NOT NULL

"}]},"200-like-operator":{"chapterName":"LIKE value","pages":[{"file":"110-select-names-starting-with-to.md","title":"

Select all names starting with To

","slug":"select-all-names-starting-with-to","is_not_exercise":true,"label":"11.1","pagePath":"/learn-sql/pages/select-all-names-starting-with-to","pageName":"

Select all names starting with To

"},{"file":"120-select-names-ending-with-r.md","title":"

Select all names ending with r

","slug":"select-all-names-ending-with-r","is_not_exercise":true,"label":"11.2","pagePath":"/learn-sql/pages/select-all-names-ending-with-r","pageName":"

Select all names ending with r

"},{"file":"130-select-names-containing-ar.md","title":"

Select all names containing ar

","slug":"select-all-names-containing-ar","is_not_exercise":true,"label":"11.3","pagePath":"/learn-sql/pages/select-all-names-containing-ar","pageName":"

Select all names containing ar

"},{"file":"140-select-where-like-ex1.md","title":"

Exercise - Select where LIKE

","slug":"exercise-select-where-like","is_not_exercise":false,"label":"11.3 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-where-like","pageName":"

Exercise - Select where LIKE

"},{"file":"150-select-where-like-ex2.md","title":"

Exercise - Select where LIKE

","slug":"exercise-select-where-like-2","is_not_exercise":false,"label":"11.3 - Ex 2","pagePath":"/learn-sql/pages/exercise-select-where-like-2","pageName":"

Exercise - Select where LIKE

"},{"file":"160-select-where-like-ex3.md","title":"

Exercise - Select where LIKE - 3

","slug":"exercise-select-where-like-3","is_not_exercise":false,"label":"11.3 - Ex 3","pagePath":"/learn-sql/pages/exercise-select-where-like-3","pageName":"

Exercise - Select where LIKE - 3

"}]},"210-not-like-operator":{"chapterName":"NOT LIKE value","pages":[{"file":"110-select-where-not-like.md","title":"

Select where NOT LIKE

","slug":"select-where-not-like","is_not_exercise":true,"label":"12.1","pagePath":"/learn-sql/pages/select-where-not-like","pageName":"

Select where NOT LIKE

"},{"file":"120-select-where-not-like-2.md","title":"

Select students course does not end with t

","slug":"select-students-course-does-not-end-with-t","is_not_exercise":true,"label":"12.2","pagePath":"/learn-sql/pages/select-students-course-does-not-end-with-t","pageName":"

Select students course does not end with t

"},{"file":"130-select-where-not-like-3.md","title":"

Select students course does not contain y

","slug":"select-students-course-does-not-contain-y","is_not_exercise":true,"label":"12.3","pagePath":"/learn-sql/pages/select-students-course-does-not-contain-y","pageName":"

Select students course does not contain y

"},{"file":"140-select-where-not-like-ex1.md","title":"

Exercise - Select whose name does not start with H

","slug":"exercise-select-whose-name-does-not-start-with-h","is_not_exercise":false,"label":"12.3 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-whose-name-does-not-start-with-h","pageName":"

Exercise - Select whose name does not start with H

"},{"file":"150-select-where-not-like-ex2.md","title":"

Exercise - Select whose name does not end with y

","slug":"exercise-select-whose-name-does-not-end-with-y","is_not_exercise":false,"label":"12.3 - Ex 2","pagePath":"/learn-sql/pages/exercise-select-whose-name-does-not-end-with-y","pageName":"

Exercise - Select whose name does not end with y

"},{"file":"160-select-where-not-like-ex3.md","title":"

Exercise - Select does not contain ony

","slug":"exercise-select-does-not-contain-ony","is_not_exercise":false,"label":"12.3 - Ex 3","pagePath":"/learn-sql/pages/exercise-select-does-not-contain-ony","pageName":"

Exercise - Select does not contain ony

"}]},"220-distinct-operator":{"chapterName":"DISTINCT operator","pages":[{"file":"110-select-distinct.md","title":"

SELECT DISTINCT

","slug":"select-distinct","is_not_exercise":true,"label":"13.1","pagePath":"/learn-sql/pages/select-distinct","pageName":"

SELECT DISTINCT

"},{"file":"120-select-distinct-ex1.md","title":"

Exercise - SELECT distinct

","slug":"exercise-select-distinct","is_not_exercise":false,"label":"13.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-distinct","pageName":"

Exercise - SELECT distinct

"}]},"230-select-specific-column":{"chapterName":"Select specific column","pages":[{"file":"110-select-name.md","title":"

Select only name

","slug":"select-only-name","is_not_exercise":true,"label":"14.1","pagePath":"/learn-sql/pages/select-only-name","pageName":"

Select only name

"},{"file":"120-select-name-and-age.md","title":"

Select only name & age

","slug":"select-only-name-age","is_not_exercise":true,"label":"14.2","pagePath":"/learn-sql/pages/select-only-name-age","pageName":"

Select only name & age

"},{"file":"130-select-name-ex1.md","title":"

Exercise - Select only a few columns

","slug":"select-name","is_not_exercise":false,"label":"14.2 - Ex 1","pagePath":"/learn-sql/pages/select-name","pageName":"

Exercise - Select only a few columns

"}]},"240-count-operator":{"chapterName":"COUNT operator","pages":[{"file":"110-select-count-all.md","title":"

Count all students

","slug":"select-count-all","is_not_exercise":true,"label":"15.1","pagePath":"/learn-sql/pages/select-count-all","pageName":"

Count all students

"},{"file":"120-select-count-column.md","title":"

COUNT from a column

","slug":"select-count-column","is_not_exercise":true,"label":"15.2","pagePath":"/learn-sql/pages/select-count-column","pageName":"

COUNT from a column

"},{"file":"130-select-count-column-ex1.md","title":"

Exercise - Count from a column

","slug":"exercise-select-count-column","is_not_exercise":false,"label":"15.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-count-column","pageName":"

Exercise - Count from a column

"}]},"250-as-operator":{"chapterName":"AS operator","pages":[{"file":"110-as.md","title":"

AS to change the column header

","slug":"as-to-change-the-column-header","is_not_exercise":true,"label":"16.1","pagePath":"/learn-sql/pages/as-to-change-the-column-header","pageName":"

AS to change the column header

"},{"file":"120-as-ex1.md","title":"

Exercise - ALIAS to change the column header

","slug":"exercise-alias","is_not_exercise":false,"label":"16.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-alias","pageName":"

Exercise - ALIAS to change the column header

"},{"file":"130-as-other-use-cases.md","title":"

AS - another example

","slug":"as-another-example","is_not_exercise":true,"label":"16.2","pagePath":"/learn-sql/pages/as-another-example","pageName":"

AS - another example

"},{"file":"140-as-ex2.md","title":"

Exercise - AS another example

","slug":"exercise-alias-2","is_not_exercise":false,"label":"16.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-alias-2","pageName":"

Exercise - AS another example

"}]},"260-count-and-distinct":{"chapterName":"COUNT & DISTINCT","pages":[{"file":"110-count-with-distinct.md","title":"

COUNT with DISTINCT

","slug":"count-with-distinct","is_not_exercise":true,"label":"17.1","pagePath":"/learn-sql/pages/count-with-distinct","pageName":"

COUNT with DISTINCT

"},{"file":"120-count-with-distinct-ex1.md","title":"

Exercise - COUNT with DISTINCT

","slug":"exercise-count-with-distinct","is_not_exercise":false,"label":"17.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-count-with-distinct","pageName":"

Exercise - COUNT with DISTINCT

"}]},"270-sum-and-average":{"chapterName":"SUM and AVG","pages":[{"file":"110-sum.md","title":"

Sum of ages

","slug":"sum-of-ages","is_not_exercise":true,"label":"18.1","pagePath":"/learn-sql/pages/sum-of-ages","pageName":"

Sum of ages

"},{"file":"120-sum-ex1.md","title":"

Exercise - Sum of marks

","slug":"exercise-sum-of-marks","is_not_exercise":false,"label":"18.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-sum-of-marks","pageName":"

Exercise - Sum of marks

"},{"file":"130-sum-ex2.md","title":"

Exercise - Sum of distinct marks under 50

","slug":"exercise-sum-of-distinct-marks-under-50","is_not_exercise":false,"label":"18.1 - Ex 2","pagePath":"/learn-sql/pages/exercise-sum-of-distinct-marks-under-50","pageName":"

Exercise - Sum of distinct marks under 50

"},{"file":"140-average.md","title":"

Average of marks

","slug":"average-of-marks","is_not_exercise":true,"label":"18.2","pagePath":"/learn-sql/pages/average-of-marks","pageName":"

Average of marks

"},{"file":"150-average-ex1.md","title":"

Exercise - Average of ages

","slug":"exercise-average-of-ages","is_not_exercise":false,"label":"18.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-average-of-ages","pageName":"

Exercise - Average of ages

"},{"file":"160-average-ex2.md","title":"

Exercise - Average of distinct ages between 8 and 13

","slug":"exercise-average-of-distinct-ages-between-8-and-13","is_not_exercise":false,"label":"18.2 - Ex 2","pagePath":"/learn-sql/pages/exercise-average-of-distinct-ages-between-8-and-13","pageName":"

Exercise - Average of distinct ages between 8 and 13

"}]},"280-max-and-min":{"chapterName":"MAX and MIN","pages":[{"file":"110-maximum.md","title":"

Maximum age

","slug":"maximum-age","is_not_exercise":true,"label":"19.1","pagePath":"/learn-sql/pages/maximum-age","pageName":"

Maximum age

"},{"file":"120-maximum-ex1.md","title":"

Exercise - Maximum marks

","slug":"exercise-maximum-marks","is_not_exercise":false,"label":"19.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-maximum-marks","pageName":"

Exercise - Maximum marks

"},{"file":"130-maximum-ex2.md","title":"

Exercise - Maximum marks in Python

","slug":"exercise-maximum-marks-in-python","is_not_exercise":false,"label":"19.1 - Ex 2","pagePath":"/learn-sql/pages/exercise-maximum-marks-in-python","pageName":"

Exercise - Maximum marks in Python

"},{"file":"140-minimum.md","title":"

Minimum marks

","slug":"minimum-marks","is_not_exercise":true,"label":"19.2","pagePath":"/learn-sql/pages/minimum-marks","pageName":"

Minimum marks

"},{"file":"150-minimum-ex1.md","title":"

Exercise - Minimum age

","slug":"exercise-minimum-age","is_not_exercise":false,"label":"19.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-minimum-age","pageName":"

Exercise - Minimum age

"},{"file":"160-minimum-ex2.md","title":"

Exercise - Minimum age of high achievers

","slug":"exercise-minimum-age-of-high-achievers","is_not_exercise":false,"label":"19.2 - Ex 2","pagePath":"/learn-sql/pages/exercise-minimum-age-of-high-achievers","pageName":"

Exercise - Minimum age of high achievers

"}]},"290-selecting-multiple-data":{"chapterName":"Select multiple data","pages":[{"file":"110-select-multiple-data.md","title":"

Select multiple data

","slug":"select-multiple-data","is_not_exercise":true,"label":"20.1","pagePath":"/learn-sql/pages/select-multiple-data","pageName":"

Select multiple data

"},{"file":"120-select-multiple-data-ex1.md","title":"

Exercise - Select multiple data

","slug":"exercise-select-multiple-data","is_not_exercise":false,"label":"20.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-multiple-data","pageName":"

Exercise - Select multiple data

"}]},"300-order-by":{"chapterName":"ORDER BY","pages":[{"file":"110-select-order-by.md","title":"

Order students by marks

","slug":"order-students-by-marks","is_not_exercise":true,"label":"21.1","pagePath":"/learn-sql/pages/order-students-by-marks","pageName":"

Order students by marks

"},{"file":"120-select-order-by-ex1.md","title":"

Exercise - Order students by ages

","slug":"exercise-order-students-by-ages","is_not_exercise":false,"label":"21.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-order-students-by-ages","pageName":"

Exercise - Order students by ages

"},{"file":"130-select-order-by-multiple-columns.md","title":"

Order students by grade and marks

","slug":"order-students-by-grade-and-marks","is_not_exercise":true,"label":"21.2","pagePath":"/learn-sql/pages/order-students-by-grade-and-marks","pageName":"

Order students by grade and marks

"},{"file":"140-select-order-by-multiple-columns-ex1.md","title":"

Exercise - Order students by grade, age and marks

","slug":"order-students-by-grade-age-and-marks","is_not_exercise":false,"label":"21.2 - Ex 1","pagePath":"/learn-sql/pages/order-students-by-grade-age-and-marks","pageName":"

Exercise - Order students by grade, age and marks

"}]},"310-order-by-ascending-and-descending":{"chapterName":"ORDER BY - Ascending and Descending","pages":[{"file":"110-select-order-by-desc.md","title":"

Order students by marks in descending order

","slug":"order-students-by-marks-in-descending-order","is_not_exercise":true,"label":"22.1","pagePath":"/learn-sql/pages/order-students-by-marks-in-descending-order","pageName":"

Order students by marks in descending order

"},{"file":"120-select-order-by-desc-ex1.md","title":"

Exercise - Order students by grades in descending order

","slug":"exercise-order-students-by-grades-in-descending-order","is_not_exercise":false,"label":"22.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-order-students-by-grades-in-descending-order","pageName":"

Exercise - Order students by grades in descending order

"},{"file":"130-select-order-by-combination-of-desc-and-asc.md","title":"

Order students by less age and more marks

","slug":"order-students-by-less-age-and-more-marks","is_not_exercise":true,"label":"22.2","pagePath":"/learn-sql/pages/order-students-by-less-age-and-more-marks","pageName":"

Order students by less age and more marks

"},{"file":"140-select-order-by-combination-of-desc-and-asc-ex1.md","title":"

Exercise - Order students by grade and id

","slug":"exercise-order-students-by-grade-and-id","is_not_exercise":false,"label":"22.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-order-students-by-grade-and-id","pageName":"

Exercise - Order students by grade and id

"}]},"320-order-by-more-use-cases":{"chapterName":"ORDER BY - More use cases","pages":[{"file":"110-select-order-in-strings.md","title":"

Order students alphabetically

","slug":"order-students-alphabetically","is_not_exercise":true,"label":"23.1","pagePath":"/learn-sql/pages/order-students-alphabetically","pageName":"

Order students alphabetically

"},{"file":"120-select-order-in-strings-ex1.md","title":"

Exercise - Order students with courses and names

","slug":"exercise-order-students-with-courses-and-names","is_not_exercise":false,"label":"23.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-order-students-with-courses-and-names","pageName":"

Exercise - Order students with courses and names

"},{"file":"130-select-order-on-modified-data.md","title":"

Order distinct courses alphabetically

","slug":"order-distinct-courses-alphabetically","is_not_exercise":true,"label":"23.2","pagePath":"/learn-sql/pages/order-distinct-courses-alphabetically","pageName":"

Order distinct courses alphabetically

"},{"file":"140-select-order-on-modified-data-ex1.md","title":"

Exercise - Sort distinct marks alphabetically in reverse order

","slug":"exercise-sort-distinct-marks-alphabetically-in-reverse-order","is_not_exercise":false,"label":"23.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-sort-distinct-marks-alphabetically-in-reverse-order","pageName":"

Exercise - Sort distinct marks alphabetically in reverse order

"}]},"330-limit":{"chapterName":"LIMIT","pages":[{"file":"110-limit.md","title":"

Select only 5 students

","slug":"select-only-5-students","is_not_exercise":true,"label":"24.1","pagePath":"/learn-sql/pages/select-only-5-students","pageName":"

Select only 5 students

"},{"file":"120-limit-ex1.md","title":"

Exercise - Select top 3 names

","slug":"exercise-select-top-3-names","is_not_exercise":false,"label":"24.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-top-3-names","pageName":"

Exercise - Select top 3 names

"},{"file":"130-limit-with-conditions.md","title":"

Select 4 students enrolled in Python or Ruby

","slug":"select-4-students-enrolled-in-python-or-ruby","is_not_exercise":true,"label":"24.2","pagePath":"/learn-sql/pages/select-4-students-enrolled-in-python-or-ruby","pageName":"

Select 4 students enrolled in Python or Ruby

"},{"file":"140-limit-with-conditions-ex1.md","title":"

Exercise - Select 6 students above age 9

","slug":"exercise-select-6-students-above-age-9","is_not_exercise":false,"label":"24.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-6-students-above-age-9","pageName":"

Exercise - Select 6 students above age 9

"}]},"340-limit-with-ordering-and-offset":{"chapterName":"LIMIT with ordering and offset","pages":[{"file":"110-limit-with-order-by.md","title":"

Select top 10 students with highest marks

","slug":"select-top-10-students-with-highest-marks","is_not_exercise":true,"label":"25.1","pagePath":"/learn-sql/pages/select-top-10-students-with-highest-marks","pageName":"

Select top 10 students with highest marks

"},{"file":"120-limit-with-order-by-ex1.md","title":"

Exercise - Select bottom 5 students with lowest marks

","slug":"exercise-select-bottom-5-students-with-lowest-marks","is_not_exercise":false,"label":"25.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-bottom-5-students-with-lowest-marks","pageName":"

Exercise - Select bottom 5 students with lowest marks

"},{"file":"130-limit-with-order-by-ex2.md","title":"

Exercise - Select last 6 students in the alphabetical order

","slug":"exercise-select-last-6-students-in-alphabetical-order","is_not_exercise":false,"label":"25.1 - Ex 2","pagePath":"/learn-sql/pages/exercise-select-last-6-students-in-alphabetical-order","pageName":"

Exercise - Select last 6 students in the alphabetical order

"},{"file":"140-limit-with-order-by-ex3.md","title":"

Exercise - Select top 3 distinct courses in the alphabetical order

","slug":"exercise-select-top-3-distinct-courses-in-alphabetical-order","is_not_exercise":false,"label":"25.1 - Ex 3","pagePath":"/learn-sql/pages/exercise-select-top-3-distinct-courses-in-alphabetical-order","pageName":"

Exercise - Select top 3 distinct courses in the alphabetical order

"},{"file":"150-limit-with-offset.md","title":"

Select top students with highest marks from rank 6 to 10

","slug":"select-top-students-with-highest-marks-from-rank-6-to-10","is_not_exercise":true,"label":"25.2","pagePath":"/learn-sql/pages/select-top-students-with-highest-marks-from-rank-6-to-10","pageName":"

Select top students with highest marks from rank 6 to 10

"},{"file":"160-limit-with-offset-ex1.md","title":"

Exercise - Select 6th student in the alphabetical order of names

","slug":"exercise-select-6th-student-in-the-alphabetical-order-of-names","is_not_exercise":false,"label":"25.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-6th-student-in-the-alphabetical-order-of-names","pageName":"

Exercise - Select 6th student in the alphabetical order of names

"}]},"350-using-length":{"chapterName":"Using LENGTH","pages":[{"file":"110-length.md","title":"

Selecting LENGTH

","slug":"selecting-length","is_not_exercise":true,"label":"26.1","pagePath":"/learn-sql/pages/selecting-length","pageName":"

Selecting LENGTH

"},{"file":"120-length-ex1.md","title":"

Exercise - Selecting LENGTH of course names

","slug":"exercise-selecting-length-of-course-names","is_not_exercise":false,"label":"26.1 - Ex 1","pagePath":"/learn-sql/pages/exercise-selecting-length-of-course-names","pageName":"

Exercise - Selecting LENGTH of course names

"},{"file":"130-filter-using-length.md","title":"

Filter using LENGTH

","slug":"filter-using-length","is_not_exercise":true,"label":"26.2","pagePath":"/learn-sql/pages/filter-using-length","pageName":"

Filter using LENGTH

"},{"file":"140-filter-using-length-ex1.md","title":"

Exercise - Select students with double digit marks

","slug":"exercise-select-students-with-double-digit-marks","is_not_exercise":false,"label":"26.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-select-students-with-double-digit-marks","pageName":"

Exercise - Select students with double digit marks

"},{"file":"150-order-using-length.md","title":"

Order using LENGTH

","slug":"order-using-length","is_not_exercise":true,"label":"26.3","pagePath":"/learn-sql/pages/order-using-length","pageName":"

Order using LENGTH

"},{"file":"160-order-using-length-ex1.md","title":"

Exercise - Order students by length of course names

","slug":"exercise-order-students-by-length-of-course-names","is_not_exercise":false,"label":"26.3 - Ex 1","pagePath":"/learn-sql/pages/exercise-order-students-by-length-of-course-names","pageName":"

Exercise - Order students by length of course names

"}]},"360-date-functions":{"chapterName":"Date functions","pages":[{"file":"110-date-function.md","title":"

Date function

","slug":"date-function","is_not_exercise":true,"label":"27.1","pagePath":"/learn-sql/pages/date-function","pageName":"

Date function

"},{"file":"120-time-function.md","title":"

Time function

","slug":"time-function","is_not_exercise":true,"label":"27.2","pagePath":"/learn-sql/pages/time-function","pageName":"

Time function

"},{"file":"130-date-and-time-function-ex1.md","title":"

Exercise - Date and Time functions

","slug":"exercise-date-and-time-function","is_not_exercise":false,"label":"27.2 - Ex 1","pagePath":"/learn-sql/pages/exercise-date-and-time-function","pageName":"

Exercise - Date and Time functions

"},{"file":"140-datetime-function.md","title":"

DATETIME function

","slug":"datetime-function","is_not_exercise":true,"label":"27.3","pagePath":"/learn-sql/pages/datetime-function","pageName":"

DATETIME function

"},{"file":"150-datetime-function-modifiers.md","title":"

DATETIME function - Modifiers

","slug":"datetime-function-modifiers","is_not_exercise":true,"label":"27.4","pagePath":"/learn-sql/pages/datetime-function-modifiers","pageName":"

DATETIME function - Modifiers

"},{"file":"160-datetime-function-ex1.md","title":"

Exercise - DATETIME function

","slug":"exercise-datetime-function-1","is_not_exercise":false,"label":"27.4 - Ex 1","pagePath":"/learn-sql/pages/exercise-datetime-function-1","pageName":"

Exercise - DATETIME function

"},{"file":"170-datetime-function-ex2.md","title":"

Exercise - DATETIME function

","slug":"exercise-datetime-function-2","is_not_exercise":false,"label":"27.4 - Ex 2","pagePath":"/learn-sql/pages/exercise-datetime-function-2","pageName":"

Exercise - DATETIME function

"},{"file":"180-strftime-function.md","title":"

STRFTIME Function

","slug":"strftime-function","is_not_exercise":true,"label":"27.5","pagePath":"/learn-sql/pages/strftime-function","pageName":"

STRFTIME Function

"},{"file":"190-strftime-function-ex1.md","title":"

Exercise - STRFTIME Function

","slug":"exercise-strftime-function","is_not_exercise":false,"label":"27.5 - Ex 1","pagePath":"/learn-sql/pages/exercise-strftime-function","pageName":"

Exercise - STRFTIME Function

"}]},"370-arithmetic-operations-on-columns":{"chapterName":"Arithmetic - Operations on columns","pages":[{"file":"110-arithmetic-operations-in-sql.md","title":"

Introduction to Modulus

","slug":"introduction-to-modulus","is_not_exercise":true,"label":"28.1","pagePath":"/learn-sql/pages/introduction-to-modulus","pageName":"

Introduction to Modulus

"},{"file":"120-finding-odd-and-even-numbers.md","title":"

Detecting even and odd with Modulus

","slug":"uses-of-modulus","is_not_exercise":true,"label":"28.2","pagePath":"/learn-sql/pages/uses-of-modulus","pageName":"

Detecting even and odd with Modulus

"},{"file":"130-finding-odd-and-even-numbers-ex1.md","title":"

Exercise - Detecting even and odd with modulus

","slug":"detect-even-odd-with-modulus-exercise","is_not_exercise":false,"label":"28.2 - Ex 1","pagePath":"/learn-sql/pages/detect-even-odd-with-modulus-exercise","pageName":"

Exercise - Detecting even and odd with modulus

"},{"file":"140-finding-odd-and-even-numbers-ex2.md","title":"

Exercise - Detecting even and odd with modulus

","slug":"detect-even-odd-with-modulus-exercise-2","is_not_exercise":false,"label":"28.2 - Ex 2","pagePath":"/learn-sql/pages/detect-even-odd-with-modulus-exercise-2","pageName":"

Exercise - Detecting even and odd with modulus

"},{"file":"150-arithmetic-operations-on-columns.md","title":"

Arithmetic operations on columns

","slug":"arithmetic-operations-on-columns","is_not_exercise":true,"label":"28.3","pagePath":"/learn-sql/pages/arithmetic-operations-on-columns","pageName":"

Arithmetic operations on columns

"},{"file":"160-arithmetic-operations-on-columns-ex1.md","title":"

Exercise - Arithmetic operations on columns

","slug":"exercise-arithmetic-operations-on-columns","is_not_exercise":false,"label":"28.3 - Ex 1","pagePath":"/learn-sql/pages/exercise-arithmetic-operations-on-columns","pageName":"

Exercise - Arithmetic operations on columns

"},{"file":"170-arithmetic-operations-on-combination-of-columns.md","title":"

Arithmetic operations on combination of columns

","slug":"arithmetic-operations-on-combination-of-columns","is_not_exercise":true,"label":"28.4","pagePath":"/learn-sql/pages/arithmetic-operations-on-combination-of-columns","pageName":"

Arithmetic operations on combination of columns

"},{"file":"180-arithmetic-operations-on-combination-of-columns-ex1.md","title":"

Exercise - Arithmetic operations on combination of columns

","slug":"exercise-arithmetic-operations-on-combination-of-columns","is_not_exercise":false,"label":"28.4 - Ex 1","pagePath":"/learn-sql/pages/exercise-arithmetic-operations-on-combination-of-columns","pageName":"

Exercise - Arithmetic operations on combination of columns

"}]},"380-arithmetic-filtering-and-ordering":{"chapterName":"Arithmetic - Filtering and Ordering","pages":[{"file":"110-arithmetic-operations-on-columns.md","title":"

Filter records with even values

","slug":"filter-even-numbers","is_not_exercise":true,"label":"29.1","pagePath":"/learn-sql/pages/filter-even-numbers","pageName":"

Filter records with even values

"},{"file":"120-filter-using-arithmetic.md","title":"

Filter using arithmetic

","slug":"filter-using-arithmetic","is_not_exercise":true,"label":"29.2","pagePath":"/learn-sql/pages/filter-using-arithmetic","pageName":"

Filter using arithmetic

"},{"file":"130-filter-using-arithmetic-ex.md","title":"