Question: use the 4 tables below to write SQL SELECT queries to display problems 1,2, and 3. (Queries of a single table with filtering conditions) TABLES

use the 4 tables below to write SQL SELECT queries to display problems 1,2, and 3. (Queries of a single table with filtering conditions)

TABLES

use the 4 tables below to write SQL SELECT queries to display1. The titles, dates, and start times of all sessions in room 101; note that the RoomID field in this database is text, not a number.

2. The room IDs, capacities, and notes for all rooms with a capacity below 100.

3. The same information as in part (2), but only for rooms capable of serving refreshments; note that in SQL the possible values of a yeso field are True and False (without the quotes).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!