- Output the names of all the Thai restaurants stored in your DB.
- Output the names of all the Brooklyn restaurants stored in your DB there were established prior to 2012.
- Show the list of restaurants together with their cuisine and location with the average price higher than $120.00
- Show the names of all the food critics who work in NYT or NYP together with the corresponding affiliation.
- Output the first and last names of the reviewers who are freelancers and to not have any affiliation.
- Output the first and last names of authors whose last name starts with the letter ‘A’.
- Show all the restaurant names whose length is less than 10 characters.
- Output all the records from the Rating table for the reviews made by the critic with cID 202.
- Output all the records from the Rating table for the reviews made by the critic with cID 210.
- Output all the records from the Rating table for the reviews with the starRating greater than
- Output the names of all the Italian Manhattan restaurants.
- Output all the names of all the Bronx restaurants with the average prices greater than $100.00
- Get the names and sex of all liberal students
- Get the names, sex, and political views of liberal and very liberal students
- Find all students who live in “Weinstein Hall”, independent of their room number
- Find all students with first name “Richard”
- Find all students with first names starting with P and last names starting with I (e.g. Panos Ipeirotis)