jp3pe

## bookstore_queries.sql
-- Challenge 1: Find the 10 longest books (by pages) in the database
SELECT
    books.title,
    author,
    pages
FROM
    books
WHERE
    pages IS NOT NULL
ORDER BY

## cte_examples.sql
-- SELECT

WITH recursive custom_cte AS
  ( SELECT
      *
    FROM
      target_table
    WHERE
      target_table.id = "value"
	-- Challenge 1: Find the 10 longest books (by pages) in the database
	SELECT
	books.title,
	author,
	pages
	FROM
	books
	WHERE
	pages IS NOT NULL
	ORDER BY
	-- SELECT

	WITH recursive custom_cte AS
	( SELECT
	*
	FROM
	target_table
	WHERE
	target_table.id = "value"