# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: Python 3
#     language: python
#     name: python3
# ---

# #### 1. You want to select author's last name from a table, but you only remember the author’s last name starts with the letter B, which string pattern can you use?

# ##### Ans: SELECT lastname from author where lastname like ‘B%’ 

# #### 2. In a SELECT statement, which SQL clause controls how the result set is displayed? 

# ##### Ans: ORDER BY clause 

# #### 3. Which SELECT statement eliminates duplicates in the result set? 

# ##### Ans: SELECT distinct(country) from author 

# #### 4. What is the default sorting mode of the ORDER BY clause? 

# ##### Ans: Ascending 

# #### 5. Which of the following can be used in a SELECT statement to restrict a result set? 

# ##### Ans: 
# <ul>
#     <li>HAVING</li>
#     <li>GROUP BY</li>
#     <li>DISTINCT</li>
# </ul>

StarcoderdataJupyterScriptsDedupFiltered