All our Data Science projects include bite-sized activities to test your knowledge and practice in an environment with constant feedback.
All our activities include solutions with explanations on how they work and why we chose them.
Write a query to select only title, rental_duration, rental_rate, and replacement_cost columns from the film table where the rating is PG.
Your result should look like this:
There are more rows in the result than shown in the image.
Write a query to select only first_name, last_name, email, and active columns from the customer table where the active column is 0.
Your result should look like this:
There are more rows in the result than shown in the image.
Write a query to select only city, and last_update columns from the city table where country is Brazil.
Your result should look like this:
There are more rows in the result than shown in the image.
Write a query to select all the columns from the address table where the district is Texas.
Your result should look like this:
Write a query to select address, district, and city_id and postal_code from the address table where the postal_code is not empty.
Your result should look like this:
There are more rows in the result than shown in the image.
Write a query to select title, rental_duration, rental_rate, and replacement_cost from the film table where the replacement_cost is less than $20.
Your result should look like this:
There are more rows in the result than shown in the image.
Write a query to select title, rental_duration, rental_rate, and replacement_cost from the film table where the rental_duration is not equal to 4.
Your result should look like this:
There are more rows in the result than shown in the image.
Write a query to select title, rental_duration, rental_rate, and replacement_cost from the film table where the length is greater than 120.
Your result should look like this:
There are more rows in the result than shown in the image.
What's up, friends! 👋 I'm a computer science student about to finish my last year of college. 🎓 I LOVE writing code! ❤️ It makes me so happy! 😄 Whether I'm goofing in notebooks 📓 or coding in Python 🐍, writing programs is a blast! 💥
