For each reservation for customer Ryan Goff , list the reservation id, trip id and number of persons.

List the location name and location ID where the location ID is 1400, 1500, or 1800. Use INoperator. Do not use OR operator.

SQL Find the guide last name and guide first name of all guides who can lead a paddling trip

Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.

Display the total number of credits earned in each year using the tot credits (year, num credits) view.

Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)

List all vendors with their address(city, state,zipcode) for all the vendors who have credited account (credit total>0)) Hint:Vendors & Invoices tables with credit total column WHERE vendors.vendor id = invoices.vendor id AND CREDIT_TOTAL>0; %3D

using SQL: Find the pub_id  of the publisher(s) that have published the LEAST expensive book

SQL BITS List client number, balance, consultant number, and consultant last name of every client whose balance is greater than that of client number '405.'

5. Which orders were placed on or before April 1, 2009? List each order number and orderdate. Write this query in two different ways.