Quotes help make search much faster. Example: "Practice Makes Perfect"

Monday, July 18, 2016

SQL: Table Transformation Lesson 15 Sample Solution


Instructions:
Count the number of rows from the flights table, where arr_time is not null and the destination is ATL.

Sample Solution:
SELECT COUNT(*) FROM flights WHERE arr_time IS NOT NULL AND destination = 'ATL';
Posted by Nathan at
Labels: ,

2 comments:

  1. GirlFromSpaceSeptember 8, 2016 at 5:59 AM

    This comment has been removed by the author.

    ReplyDelete
  2. GirlFromSpaceSeptember 8, 2016 at 6:02 AM

    Hi there. This solution did not work for me, I ended up using
    SELECT COUNT(*)
    FROM flights
    WHERE destination = 'ATL';
    which passed the check to move onto the next question.

    ReplyDelete

Subscribe to: Post Comments (Atom)

This is an example of scrolling text using Javascript.

Popular Posts