contestada

Fill in the necessary blanks to list the name of each trip that does not start in New Hampshire (NH) Use the Colonial Adventure Tour Database listing found on the Canvas webpage under Databases or in the text.
SELECT TripName
FROM______
WHERE Trip____ ____NH:

Respuesta :

MrRoyal

Answer:

SELECT TripName

FROM AllTrips

WHERE Trip NOT LIKE ‘NH%'

Explanation:

Required

Fill in the blanks

The table name is not stated; so, I assumed the table name to be AllTrips.

The explanation is as follows:

This select the records in the TripName column

SELECT TripName

This specifies the table where the record is being selected

FROM AllTrips

This states the fetch condition

WHERE Trip NOT LIKE ‘NH%'

Note that:

  • The wild card 'NH%' means, record that begins with NH
  • Not means opposite

So, the clause NOT LIKE 'NH%' will return records that do not begin with NH

Otras preguntas