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
1. 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
Get step-by-step solutions from verified subject matter experts
