Exercise

SQL basics

Time to begin writing queries for your first hotel booking chatbot! The database has been loaded as "hotels.db" and a cursor, which has access to the database, has already been defined for you as cursor.

Three queries are provided below. Your job is to identify which query returns ONLY the "Hotel California".

You can test each query below by calling the cursor's .execute() method and passing the query in as a string. Then, you can print the results by calling the cursor's .fetchall() method, which takes no arguments.

Instructions

50 XP

Possible answers

SELECT name from hotels where price = 'expensive' AND area = 'center'

SELECT name from hotels where price = 'mid' AND area = 'north'

SELECT name from hotels where price = 'expensive'