Skip to content

Latest commit

 

History

History
39 lines (32 loc) · 647 Bytes

chapter1.md

File metadata and controls

39 lines (32 loc) · 647 Bytes
Raw
title description
sqlwhat examples (intro to SQL)
Examples of the intro to SQL for Data Science course

Example 1

type: NormalExercise
xp: 100
key: 6e8f40e2bb

@instructions Select the title column from the films table.

@pre_exercise_code

connect('postgresql', 'films')

@solution

SELECT title
FROM films;

@sct

Ex().check_correct(
    check_col('title').is_equal(),
    check_node('SelectStmt').multi(
        check_field('target_list', 0).has_equal_ast(),
        check_field('from_clause').has_equal_ast()
    )
)
Ex().success_msg("You are awesome!")