{"isTableOfContentPresent":true,"courseSlug":"learn-sql","chapters":{"110-getting-started":{"chapterName":"Getting Started","tocColumnsForDisplay":[[{"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","tocColumnsForDisplay":[[{"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 *

"}],[null]]},"130-select-and-filter":{"chapterName":"Select and filter","tocColumnsForDisplay":[[{"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":"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

"}]]},"140-less-than-greater-than":{"chapterName":"Less than and greater than","tocColumnsForDisplay":[[{"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":"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

"}]]},"150-less-than-greater-than-with-equal-to":{"chapterName":"Less than and greater than with equal to","tocColumnsForDisplay":[[{"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":"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

"}]]},"155-comments":{"chapterName":"Comments","tocColumnsForDisplay":[[{"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":"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

"}]]},"160-and-or-operator":{"chapterName":"AND & OR","tocColumnsForDisplay":[[{"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":"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":"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

"},null]]},"170-between-and-not-between-operator":{"chapterName":"BETWEEN & NOT BETWEEN","tocColumnsForDisplay":[[{"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":"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":"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

"},null]]},"180-in-and-not-in-operator":{"chapterName":"IN & NOT IN","tocColumnsForDisplay":[[{"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":"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

"}]]},"190-null-operator":{"chapterName":"NULL value","tocColumnsForDisplay":[[{"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":"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

"},null]]},"200-like-operator":{"chapterName":"LIKE value","tocColumnsForDisplay":[[{"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

"},null]]},"210-not-like-operator":{"chapterName":"NOT LIKE value","tocColumnsForDisplay":[[{"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

"},null]]},"220-distinct-operator":{"chapterName":"DISTINCT operator","tocColumnsForDisplay":[[{"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

"}],[null]]},"230-select-specific-column":{"chapterName":"Select specific column","tocColumnsForDisplay":[[{"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

"}]]},"240-count-operator":{"chapterName":"COUNT operator","tocColumnsForDisplay":[[{"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

"}]]},"250-as-operator":{"chapterName":"AS operator","tocColumnsForDisplay":[[{"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":"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

"}]]},"260-count-and-distinct":{"chapterName":"COUNT & DISTINCT","tocColumnsForDisplay":[[{"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

"}],[null]]},"270-sum-and-average":{"chapterName":"SUM and AVG","tocColumnsForDisplay":[[{"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":"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

"}]]},"280-max-and-min":{"chapterName":"MAX and MIN","tocColumnsForDisplay":[[{"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":"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

"}]]},"290-selecting-multiple-data":{"chapterName":"Select multiple data","tocColumnsForDisplay":[[{"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

"}],[null]]},"300-order-by":{"chapterName":"ORDER BY","tocColumnsForDisplay":[[{"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":"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

"}]]},"310-order-by-ascending-and-descending":{"chapterName":"ORDER BY - Ascending and Descending","tocColumnsForDisplay":[[{"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":"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

"}]]},"320-order-by-more-use-cases":{"chapterName":"ORDER BY - More use cases","tocColumnsForDisplay":[[{"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":"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

"}]]},"330-limit":{"chapterName":"LIMIT","tocColumnsForDisplay":[[{"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":"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

"}]]},"340-limit-with-ordering-and-offset":{"chapterName":"LIMIT with ordering and offset","tocColumnsForDisplay":[[{"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":"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

"}]]},"350-using-length":{"chapterName":"Using LENGTH","tocColumnsForDisplay":[[{"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":"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":"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

"},null]]},"360-date-functions":{"chapterName":"Date functions","tocColumnsForDisplay":[[{"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":"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":"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

"},null]]},"370-arithmetic-operations-on-columns":{"chapterName":"Arithmetic - Operations on columns","tocColumnsForDisplay":[[{"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":"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":"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

"}]]},"380-arithmetic-filtering-and-ordering":{"chapterName":"Arithmetic - Filtering and Ordering","tocColumnsForDisplay":[[{"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":"150-modulo-operation.md","title":"

Modulo operation

","slug":"modulo-operation","is_not_exercise":true,"label":"29.3","pagePath":"/learn-sql/pages/modulo-operation","pageName":"

Modulo operation

"},{"file":"170-order-using-arithmetic.md","title":"

Order using arithmetic

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

Order using arithmetic

"}]]},"390-selecting-modified-data-from-rows":{"chapterName":"Selecting modified data from rows","tocColumnsForDisplay":[[{"file":"110-selecting-boolean-data-from-rows.md","title":"

Selecting boolean data from rows

","slug":"selecting-boolean-data-from-rows","is_not_exercise":true,"label":"30.1","pagePath":"/learn-sql/pages/selecting-boolean-data-from-rows","pageName":"

Selecting boolean data from rows

"},{"file":"130-selecting-non-column-data-from-rows.md","title":"

Selecting non-column data from rows

","slug":"selecting-non-column-data-from-rows","is_not_exercise":true,"label":"30.2","pagePath":"/learn-sql/pages/selecting-non-column-data-from-rows","pageName":"

Selecting non-column data from rows

"}],[{"file":"150-selecting-conditional-data-from-rows.md","title":"

Selecting conditional data from rows

","slug":"selecting-conditional-data-from-rows","is_not_exercise":true,"label":"30.3","pagePath":"/learn-sql/pages/selecting-conditional-data-from-rows","pageName":"

Selecting conditional data from rows

"},null]]},"400-combining-data-from-columns":{"chapterName":"Combining data from columns","tocColumnsForDisplay":[[{"file":"110-concatening-data-from-columns.md","title":"

Concatenating data from columns

","slug":"concatenating-data-from-columns","is_not_exercise":true,"label":"31.1","pagePath":"/learn-sql/pages/concatenating-data-from-columns","pageName":"

Concatenating data from columns

"}],[null]]},"410-handling-null":{"chapterName":"Handling NULL","tocColumnsForDisplay":[[{"file":"110-ifnull.md","title":"

IFNULL

","slug":"ifnull","is_not_exercise":true,"label":"32.1","pagePath":"/learn-sql/pages/ifnull","pageName":"

IFNULL

"}],[{"file":"130-coalesce.md","title":"

COALESCE

","slug":"coalesce","is_not_exercise":true,"label":"32.2","pagePath":"/learn-sql/pages/coalesce","pageName":"

COALESCE

"}]]},"420-group-by-with-count":{"chapterName":"GROUP BY - with COUNT","tocColumnsForDisplay":[[{"file":"110-count-students-in-each-grade.md","title":"

Count students in each grade

","slug":"count-students-in-each-grade","is_not_exercise":true,"label":"33.1","pagePath":"/learn-sql/pages/count-students-in-each-grade","pageName":"

Count students in each grade

"}],[null]]},"430-group-by-with-other-aggregate-functions":{"chapterName":"GROUP BY - with other aggregate functions","tocColumnsForDisplay":[[{"file":"110-group-by-and-aggregate-functions.md","title":"

GROUP BY and aggregate functions

","slug":"group-by-and-aggregate-functions","is_not_exercise":true,"label":"34.1","pagePath":"/learn-sql/pages/group-by-and-aggregate-functions","pageName":"

GROUP BY and aggregate functions

"}],[null]]},"440-group-by-more-use-cases":{"chapterName":"GROUP BY - more use cases","tocColumnsForDisplay":[[{"file":"110-group-by-modified-column-data.md","title":"

GROUP BY modified column data

","slug":"group-by-modified-column-data","is_not_exercise":true,"label":"35.1","pagePath":"/learn-sql/pages/group-by-modified-column-data","pageName":"

GROUP BY modified column data

"},{"file":"130-group-by-combined-with-ordering.md","title":"

GROUP BY with ordering

","slug":"group-by-with-ordering","is_not_exercise":true,"label":"35.2","pagePath":"/learn-sql/pages/group-by-with-ordering","pageName":"

GROUP BY with ordering

"}],[{"file":"150-filters-over-groups.md","title":"

Filters over results from GROUP BY

","slug":"filters-over-results-from-group-by","is_not_exercise":true,"label":"35.3","pagePath":"/learn-sql/pages/filters-over-results-from-group-by","pageName":"

Filters over results from GROUP BY

"},null]]},"450-group-by-multiple-columns":{"chapterName":"GROUP BY - multiple columns","tocColumnsForDisplay":[[{"file":"110-group-by-multiple-columns.md","title":"

GROUP BY over multiple columns

","slug":"group-by-multiple-columns","is_not_exercise":true,"label":"36.1","pagePath":"/learn-sql/pages/group-by-multiple-columns","pageName":"

GROUP BY over multiple columns

"}],[null]]},"460-group-by-group-concat":{"chapterName":"GROUP BY - GROUP_CONCAT","tocColumnsForDisplay":[[{"file":"110-group-concat.md","title":"

GROUP_CONCAT

","slug":"group-concat","is_not_exercise":true,"label":"37.1","pagePath":"/learn-sql/pages/group-concat","pageName":"

GROUP_CONCAT

"}],[null]]},"470-joins-inner-join":{"chapterName":"JOINS - INNER JOIN","tocColumnsForDisplay":[[{"file":"110-context-for-joins.md","title":"

Context for JOINS

","slug":"context-for-joins","is_not_exercise":true,"label":"38.1","pagePath":"/learn-sql/pages/context-for-joins","pageName":"

Context for JOINS

"},{"file":"120-inner-join-part1.md","title":"

INNER JOIN

","slug":"inner-join-part1","is_not_exercise":true,"label":"38.2","pagePath":"/learn-sql/pages/inner-join-part1","pageName":"

INNER JOIN

"},{"file":"130-inner-join-part2.md","title":"

INNER JOIN - Continued

","slug":"inner-join-part2","is_not_exercise":true,"label":"38.3","pagePath":"/learn-sql/pages/inner-join-part2","pageName":"

INNER JOIN - Continued

"}],[{"file":"140-inner-join-part3.md","title":"

INNER JOIN - Column aliases for distinction

","slug":"inner-join-part3","is_not_exercise":true,"label":"38.4","pagePath":"/learn-sql/pages/inner-join-part3","pageName":"

INNER JOIN - Column aliases for distinction

"},{"file":"170-aliasing-table-names-in-join.md","title":"

Aliasing table names in JOIN

","slug":"aliasing-table-names-in-JOIN","is_not_exercise":true,"label":"38.5","pagePath":"/learn-sql/pages/aliasing-table-names-in-JOIN","pageName":"

Aliasing table names in JOIN

"},null]]},"480-joins-outer-join":{"chapterName":"JOINS - OUTER JOIN","tocColumnsForDisplay":[[{"file":"110-left-outer-join.md","title":"

LEFT OUTER JOIN

","slug":"left-outer-join","is_not_exercise":true,"label":"39.1","pagePath":"/learn-sql/pages/left-outer-join","pageName":"

LEFT OUTER JOIN

"}],[null]]},"490-joins-self-join":{"chapterName":"JOINS - SELF JOIN","tocColumnsForDisplay":[[{"file":"110-self-join.md","title":"

SELF JOIN

","slug":"self-join","is_not_exercise":true,"label":"40.1","pagePath":"/learn-sql/pages/self-join","pageName":"

SELF JOIN

"}],[null]]},"500-joining-multiple-tables":{"chapterName":"JOINS - Multiple tables","tocColumnsForDisplay":[[{"file":"110-joining-more-than-2-tables.md","title":"

Joining more than 2 tables

","slug":"joining-more-than-2-tables","is_not_exercise":true,"label":"41.1","pagePath":"/learn-sql/pages/joining-more-than-2-tables","pageName":"

Joining more than 2 tables

"}],[null]]},"510-joins-filtering-and-ordering":{"chapterName":"JOINS - Filtering and Ordering","tocColumnsForDisplay":[[{"file":"110-joins-with-filtering.md","title":"

JOINs with filters

","slug":"joins-with-filtering","is_not_exercise":true,"label":"42.1","pagePath":"/learn-sql/pages/joins-with-filtering","pageName":"

JOINs with filters

"}],[{"file":"140-joins-with-ordering.md","title":"

JOINs with ordering

","slug":"joins-with-ordering","is_not_exercise":true,"label":"42.2","pagePath":"/learn-sql/pages/joins-with-ordering","pageName":"

JOINs with ordering

"}]]},"520-joins-grouping":{"chapterName":"JOINS - Grouping","tocColumnsForDisplay":[[{"file":"110-joins-with-group-by.md","title":"

JOINs with GROUP BY

","slug":"joins-with-group-by","is_not_exercise":true,"label":"43.1","pagePath":"/learn-sql/pages/joins-with-group-by","pageName":"

JOINs with GROUP BY

"}],[null]]},"530-joins-complex-grouping":{"chapterName":"JOINS - Complex grouping","tocColumnsForDisplay":[[{"file":"110-grouping-across-more-than-2-tables.md","title":"

Grouping across more than 2 tables

","slug":"grouping-across-more-than-2-tables","is_not_exercise":true,"label":"44.1","pagePath":"/learn-sql/pages/grouping-across-more-than-2-tables","pageName":"

Grouping across more than 2 tables

"}],[null]]},"540-joins-cartesian-product":{"chapterName":"JOINS - Cartesian Product","tocColumnsForDisplay":[[{"file":"110-cartesian-product-using-joins.md","title":"

Cartesian product using JOINs

","slug":"cartesian-product-using-joins","is_not_exercise":true,"label":"45.1","pagePath":"/learn-sql/pages/cartesian-product-using-joins","pageName":"

Cartesian product using JOINs

"}],[{"file":"130-cartesian-product-using-self-joins-and-filters.md","title":"

Cartesian product using SELF JOINs and filters

","slug":"cartesian-product-using-self-joins-and-filters","is_not_exercise":true,"label":"45.2","pagePath":"/learn-sql/pages/cartesian-product-using-self-joins-and-filters","pageName":"

Cartesian product using SELF JOINs and filters

"}]]},"550-union":{"chapterName":"UNION","tocColumnsForDisplay":[[{"file":"110-union.md","title":"

UNION

","slug":"union","is_not_exercise":true,"label":"46.1","pagePath":"/learn-sql/pages/union","pageName":"

UNION

"}],[{"file":"140-union-all.md","title":"

UNION ALL

","slug":"union-all","is_not_exercise":true,"label":"46.2","pagePath":"/learn-sql/pages/union-all","pageName":"

UNION ALL

"}]]},"560-intersection-and-except":{"chapterName":"INTERSECT and EXCEPT","tocColumnsForDisplay":[[{"file":"110-intersection.md","title":"

INTERSECT

","slug":"intersection","is_not_exercise":true,"label":"47.1","pagePath":"/learn-sql/pages/intersection","pageName":"

INTERSECT

"}],[{"file":"130-except.md","title":"

EXCEPT

","slug":"except","is_not_exercise":true,"label":"47.2","pagePath":"/learn-sql/pages/except","pageName":"

EXCEPT

"}]]},"570-subqueries":{"chapterName":"Subqueries","tocColumnsForDisplay":[[{"file":"110-subqueries.md","title":"

Subqueries

","slug":"subqueries","is_not_exercise":true,"label":"48.1","pagePath":"/learn-sql/pages/subqueries","pageName":"

Subqueries

"}],[{"file":"140-subqueries-with-multiple-results.md","title":"

Subqueries with multiple results

","slug":"subqueries-with-multiple-results","is_not_exercise":true,"label":"48.2","pagePath":"/learn-sql/pages/subqueries-with-multiple-results","pageName":"

Subqueries with multiple results

"}]]},"580-subqueries-in-from-clause":{"chapterName":"Subqueries in FROM clause","tocColumnsForDisplay":[[{"file":"110-subqueries-in-from.md","title":"

Subqueries in FROM

","slug":"subqueries-in-from","is_not_exercise":true,"label":"49.1","pagePath":"/learn-sql/pages/subqueries-in-from","pageName":"

Subqueries in FROM

"}],[null]]},"590-correlated-subqueries":{"chapterName":"Correlated subqueries","tocColumnsForDisplay":[[{"file":"110-correlated-subqueries-in-filter.md","title":"

Correlated subqueries in filter

","slug":"correlated-subqueries-in-filter","is_not_exercise":true,"label":"50.1","pagePath":"/learn-sql/pages/correlated-subqueries-in-filter","pageName":"

Correlated subqueries in filter

"}],[{"file":"130-correlated-subqueries-in-select.md","title":"

Correlated subqueries in SELECT

","slug":"correlated-subqueries-in-select","is_not_exercise":true,"label":"50.2","pagePath":"/learn-sql/pages/correlated-subqueries-in-select","pageName":"

Correlated subqueries in SELECT

"}]]},"600-subqueries-with-exists-operator":{"chapterName":"Subqueries - EXISTS operator","tocColumnsForDisplay":[[{"file":"110-subqueries-exists-operator.md","title":"

Subqueries - EXISTS operator

","slug":"subqueries-exists-operator","is_not_exercise":true,"label":"51.1","pagePath":"/learn-sql/pages/subqueries-exists-operator","pageName":"

Subqueries - EXISTS operator

"}],[{"file":"140-subqueries-not-exists-operator.md","title":"

Subqueries - NOT EXISTS operator

","slug":"subqueries-not-exists-operator","is_not_exercise":true,"label":"51.2","pagePath":"/learn-sql/pages/subqueries-not-exists-operator","pageName":"

Subqueries - NOT EXISTS operator

"}]]},"610-creating-tables":{"chapterName":"Creating tables","tocColumnsForDisplay":[[{"file":"110-create-table.md","title":"

CREATE TABLE

","slug":"create-table-statement","is_not_exercise":true,"label":"52.1","pagePath":"/learn-sql/pages/create-table-statement","pageName":"

CREATE TABLE

"}],[{"file":"130-create-table-data-types.md","title":"

CREATE TABLE - Data types

","slug":"create-table-data-types","is_not_exercise":true,"label":"52.2","pagePath":"/learn-sql/pages/create-table-data-types","pageName":"

CREATE TABLE - Data types

"}]]},"620-inserting-data-in-tables":{"chapterName":"Inserting data in tables","tocColumnsForDisplay":[[{"file":"110-inserting-records-in-a-table.md","title":"

Inserting records in a table

","slug":"inserting-records-in-a-table","is_not_exercise":true,"label":"53.1","pagePath":"/learn-sql/pages/inserting-records-in-a-table","pageName":"

Inserting records in a table

"},{"file":"130-inserting-null-records.md","title":"

Inserting NULL records

","slug":"inserting-null-records","is_not_exercise":true,"label":"53.2","pagePath":"/learn-sql/pages/inserting-null-records","pageName":"

Inserting NULL records

"},{"file":"150-inserting-multiple-records.md","title":"

Inserting multiple records

","slug":"inserting-multiple-records","is_not_exercise":true,"label":"53.3","pagePath":"/learn-sql/pages/inserting-multiple-records","pageName":"

Inserting multiple records

"}],[{"file":"170-inserting-records-in-specific-columns.md","title":"

Inserting records in specific columns

","slug":"inserting-records-in-specific-columns","is_not_exercise":true,"label":"53.4","pagePath":"/learn-sql/pages/inserting-records-in-specific-columns","pageName":"

Inserting records in specific columns

"},{"file":"190-inserting-records-summary.md","title":"

Inserting records in a table - Summary

","slug":"inserting-records-summary","is_not_exercise":true,"label":"53.5","pagePath":"/learn-sql/pages/inserting-records-summary","pageName":"

Inserting records in a table - Summary

"},null]]},"630-executing-multiple-statements":{"chapterName":"Executing multiple statements","tocColumnsForDisplay":[[{"file":"110-executing-multiple-statements.md","title":"

Executing multiple SQL statements

","slug":"executing-multiple-sql-statements","is_not_exercise":true,"label":"54.1","pagePath":"/learn-sql/pages/executing-multiple-sql-statements","pageName":"

Executing multiple SQL statements

"}],[null]]},"640-column-constraints-not-null-and-unique":{"chapterName":"Column constraints - NOT NULL and UNIQUE","tocColumnsForDisplay":[[{"file":"110-not-null-constraint.md","title":"

NOT NULL Constraint

","slug":"not-null-constraint","is_not_exercise":true,"label":"55.1","pagePath":"/learn-sql/pages/not-null-constraint","pageName":"

NOT NULL Constraint

"},{"file":"130-unique-constraint.md","title":"

UNIQUE Constraint

","slug":"unique-constraint","is_not_exercise":true,"label":"55.2","pagePath":"/learn-sql/pages/unique-constraint","pageName":"

UNIQUE Constraint

"}],[{"file":"150-combining-constraints.md","title":"

Combining constraints

","slug":"combining-constraints","is_not_exercise":true,"label":"55.3","pagePath":"/learn-sql/pages/combining-constraints","pageName":"

Combining constraints

"},null]]},"650-column-constraints-default-and-check":{"chapterName":"Column constraints - DEFAULT and CHECK","tocColumnsForDisplay":[[{"file":"110-default-constraint.md","title":"

DEFAULT Constraint

","slug":"default-constraint","is_not_exercise":true,"label":"56.1","pagePath":"/learn-sql/pages/default-constraint","pageName":"

DEFAULT Constraint

"}],[{"file":"130-check-constraint.md","title":"

CHECK Constraint

","slug":"check-constraint","is_not_exercise":true,"label":"56.2","pagePath":"/learn-sql/pages/check-constraint","pageName":"

CHECK Constraint

"}]]},"660-table-constraints-primary-key":{"chapterName":"Table constraints - PRIMARY KEY","tocColumnsForDisplay":[[{"file":"110-primary-key.md","title":"

PRIMARY KEY

","slug":"primary-key","is_not_exercise":true,"label":"57.1","pagePath":"/learn-sql/pages/primary-key","pageName":"

PRIMARY KEY

"},{"file":"120-primary-key-continued.md","title":"

PRIMARY KEY - Continued

","slug":"primary-key-continued","is_not_exercise":true,"label":"57.2","pagePath":"/learn-sql/pages/primary-key-continued","pageName":"

PRIMARY KEY - Continued

"}],[{"file":"140-primary-key-multiple-columns.md","title":"

PRIMARY KEY with multiple columns

","slug":"primary-key-multiple-columns","is_not_exercise":true,"label":"57.3","pagePath":"/learn-sql/pages/primary-key-multiple-columns","pageName":"

PRIMARY KEY with multiple columns

"},null]]},"670-primary-key-autoincrement":{"chapterName":"PRIMARY KEY - AUTOINCREMENT","tocColumnsForDisplay":[[{"file":"110-primary-key-autoincrement.md","title":"

PRIMARY KEY - AUTOINCREMENT

","slug":"primary-key-autoincrement","is_not_exercise":true,"label":"58.1","pagePath":"/learn-sql/pages/primary-key-autoincrement","pageName":"

PRIMARY KEY - AUTOINCREMENT

"}],[null]]},"680-table-constraints-foreign-key":{"chapterName":"Table constraints - FOREIGN KEY","tocColumnsForDisplay":[[{"file":"110-foreign-key.md","title":"

FOREIGN KEY

","slug":"foreign-key","is_not_exercise":true,"label":"59.1","pagePath":"/learn-sql/pages/foreign-key","pageName":"

FOREIGN KEY

"},{"file":"120-foreign-key-validations.md","title":"

FOREIGN KEY - Validations

","slug":"foreign-key-validations","is_not_exercise":true,"label":"59.2","pagePath":"/learn-sql/pages/foreign-key-validations","pageName":"

FOREIGN KEY - Validations

"}],[{"file":"130-foreign-key-multiple.md","title":"

FOREIGN KEY - Multiple foreign keys

","slug":"foreign-key-multiple","is_not_exercise":true,"label":"59.3","pagePath":"/learn-sql/pages/foreign-key-multiple","pageName":"

FOREIGN KEY - Multiple foreign keys

"},null]]},"690-updating-data-in-tables":{"chapterName":"Updating data in tables","tocColumnsForDisplay":[[{"file":"110-updating-data-in-a-column.md","title":"

Updating data in a column

","slug":"updating-data-in-a-column","is_not_exercise":true,"label":"60.1","pagePath":"/learn-sql/pages/updating-data-in-a-column","pageName":"

Updating data in a column

"},{"file":"130-updating-data-in-multiple-columns.md","title":"

Updating data in multiple columns

","slug":"updating-data-in-multiple-columns","is_not_exercise":true,"label":"60.2","pagePath":"/learn-sql/pages/updating-data-in-multiple-columns","pageName":"

Updating data in multiple columns

"}],[{"file":"150-updating-data-in-all-rows.md","title":"

Updating data in all rows

","slug":"updating-data-in-all-rows","is_not_exercise":true,"label":"60.3","pagePath":"/learn-sql/pages/updating-data-in-all-rows","pageName":"

Updating data in all rows

"},null]]},"700-deleting-data-from-tables":{"chapterName":"Deleting data from tables","tocColumnsForDisplay":[[{"file":"110-deleting-specific-data-from-table.md","title":"

Deleting specific data from table

","slug":"deleting-specific-data-from-table","is_not_exercise":true,"label":"61.1","pagePath":"/learn-sql/pages/deleting-specific-data-from-table","pageName":"

Deleting specific data from table

"}],[{"file":"130-deleting-all-data-from-table.md","title":"

Deleting all data from table

","slug":"deleting-all-data-from-table","is_not_exercise":true,"label":"61.2","pagePath":"/learn-sql/pages/deleting-all-data-from-table","pageName":"

Deleting all data from table

"}]]},"710-adding-and-updating-columns":{"chapterName":"Adding and updating columns","tocColumnsForDisplay":[[{"file":"110-adding-columns-to-table.md","title":"

Adding columns to table

","slug":"adding-columns-to-table","is_not_exercise":true,"label":"62.1","pagePath":"/learn-sql/pages/adding-columns-to-table","pageName":"

Adding columns to table

"}],[{"file":"130-renaming-columns-in-table.md","title":"

Renaming columns in table

","slug":"renaming-columns-in-table","is_not_exercise":true,"label":"62.2","pagePath":"/learn-sql/pages/renaming-columns-in-table","pageName":"

Renaming columns in table

"}]]},"720-renaming-and-deleting-tables":{"chapterName":"Renaming and deleting tables","tocColumnsForDisplay":[[{"file":"110-renaming-tables.md","title":"

Renaming tables

","slug":"renaming-tables","is_not_exercise":true,"label":"63.1","pagePath":"/learn-sql/pages/renaming-tables","pageName":"

Renaming tables

"}],[{"file":"130-deleting-tables.md","title":"

Deleting tables

","slug":"deleting-tables","is_not_exercise":true,"label":"63.2","pagePath":"/learn-sql/pages/deleting-tables","pageName":"

Deleting tables

"}]]},"730-sql-statements-with-subqueries":{"chapterName":"SQL statements with subqueries","tocColumnsForDisplay":[[{"file":"110-copying-data-from-one-table-to-another.md","title":"

Copying data from one table to another

","slug":"copying-data-from-one-table-to-another","is_not_exercise":true,"label":"64.1","pagePath":"/learn-sql/pages/copying-data-from-one-table-to-another","pageName":"

Copying data from one table to another

"}],[{"file":"140-updating-data-using-subqueries.md","title":"

Updating data using subqueries

","slug":"updating-data-using-subqueries","is_not_exercise":true,"label":"64.2","pagePath":"/learn-sql/pages/updating-data-using-subqueries","pageName":"

Updating data using subqueries

"}]]},"740-views":{"chapterName":"VIEWS","tocColumnsForDisplay":[[{"file":"110-views.md","title":"

VIEWS

","slug":"views","is_not_exercise":true,"label":"65.1","pagePath":"/learn-sql/pages/views","pageName":"

VIEWS

"}],[null]]}}}