(CS50 SQL) PROBLEM SET 1 - Packages | SOLUTION

––– DISCLAIMER –––

The following videos are for educational purposes only. Cheating or any other activities are highly discouraged!! Using another person’s code breaks the academic honesty guidelines. This solution is for those who have finished the problem sets and want to watch for educational purposes, learning experience, and exploring alternative ways to approach problems and is NOT meant for those actively doing the problem sets. All problem sets presented in this video are owned by Harvard University.

–––

[AlexVais-dt]

Thank you very much you helped me because I stucked and now I understood how to work with this!

[cruseder]

This is how I've done the first question. :) Just checking this video to see if I was correct, which I was.

query = "SELECT address, type FROM addresses WHERE id IN" \
" (SELECT address_id FROM scans WHERE package_id =" \
" (SELECT id FROM packages WHERE from_address_id =" \
" (SELECT id FROM addresses WHERE address = '900 Somerville Avenue') AND contents LIKE '%congratulatory%'))"

[elsharawyx]

Excellent video, thank u from argentina

[catiemcintosh]

I am struggling as I cant see the data like this on my side. Do you have a video of how you can get the date exported?

[danielcasallas]

why dont you add quotation marks for the column names?

[leocrypto]

My mistake was to take just the latest package ID thinking that was the latest packages sent...

[Barkev__]

I'm stuck in Week3 please make a video about it

[biswajitsarker_Multi_]

Q1.

SELECT type, address FROM addresses
WHERE id = (
SELECT to_address_id
FROM packages
WHERE from_address_id = (
SELECT id FROM addresses
WHERE address = "900 Somerville Avenue"
)
);