TPS 9

Think

Insert a new row just below the header in the table in your TPS Google Doc. Fill in the first two columns. Add your response to the problem below in the "Think"column.

Suppose I have a the following two relational tables:

What does the following SQL statement do?

SELECT name, description, priority * FROM TodoLists
    JOIN TodoItems on TodoLists.id = list_id
    WHERE is_done = 0;

Pair

If you are joining the class live (in person or over Zoom), pair up with someone when asked to do so—please use Discord or your preferred means of interacting with someone to share your answers (please see the announcement with details about Discord).  Settle on an answer between to two or three of you and put that answer down in your "Pair" column.

Share

Regardless of whether or not you are attending live, one person from your pair group should add your answer to the "TPS class share Links to an external site." document (make sure you're logged into your Endicott gmail account).

Submit

Finally, submit your personal TPS Google doc to this assignment.