Chapter 8, Problem 20MC

The tblCities table contains a numeric field named Population. Which of the following LINQ statements selects all cities having a population that exceeds 15000?a. Dim records = From city In CitiesDataSet.tblCities                            Where Population > 15000 Select cityb. Dim records = From city In CitiesDataSet.tblCities                            Select city.Population > 15000c. Dim records = From city In CitiesDataSet.tblCities                            Where city.Population > 15000                            Select city d. Dim records = Select city.Population > 15000                              From tblCities

The APPT_DTTM column stores the date and time of an appointment. Which of the following expressions would return TRUE for all appointments on January 1, 2018, and FALSE for all other appointments? SELECT ONE OF THE FOLLOWING A. APPT_DTTM >= '1 JAN 2018' AND APPT_DTTM < '2 JAN 2018' B. APPT_DTTM = '1 JAN 2018' C. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM <= '1 JAN 2018' D. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM < '2 JAN 2018' Choose one correct answer and what is output of remaining queries with proper explanation

This does not work: CREATE OR REPLACE TRIGGER trg_char_hours AFTER INSERT ON CHARTER FOR EACH ROW BEGIN UPDATE AIRCRAFT SET AC_TTAF = AC_TTAF + NEW.CHAR_HOURS_FLOWN, AC_TTEL = AC_TTEL + NEW.CHAR_HOURS_FLOWN, AC_TTER = AC_TTER + NEW.CHAR_HOURS_FLOWN WHERE AIRCRAFT.AC_NUMBER = NEW.AC_NUMBER; END; I get the following error:   ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER trg_char_hours AFTER INSERT ON CHARTER FOR EACH ROW BEGIN UPDATE AIRCRAF' at line 1   Here is the original question:   Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)

SELECT MAX(datediff(minute,start_time,end_time)) as "Longest_ride", MIN(datediff(minute,start_time,end_time)) as "shortest_ride" from RIDE LIMIT 0, 1000    Error Code: 1582. Incorrect parameter count in the call to native function 'datediff'    0.00034 sec   How do I solve this SQL error

53. Which SELECT statement retrieves the customer name for those that have a salesperson number of 137? A: SELECT CUSTNAME FROM CUSTOMER WHERE SPNUM 137; B: SELECT* FROM CUSTNAME WHERE SPNUM=137; C: SELECT CUSTOMER FROM CUSTNAME WHERE SPNUM=137; D:SELECT* FROM CUSTOMER WHERE SPNUM=137