All Ingredients Required | Intermediate SQL Problem

Опубликовано: 02 Апрель 2025
на канале: Write a SQL Query

In this video we write a SQL query to help a home cook identify recipes that only use ingredients that are currently available in the kitchen.

Video chapters
00:00 - Problem description and set-up
02:49 - Picking the correct join
05:22 - Using COUNT
07:36 - Two possible solutions
09:56 - Final thoughts and outro

If you would like to follow along at home and have a crack at solving this problem:
Local environment set-up instructions are in the Write a SQL Query GitHub repo README: https://github.com/cedwards036/write-...
The problem set-up code for today's episode can be found here: https://github.com/cedwards036/write-...

Thumbnail art and channel logo: FriezerBurnt https://www.friezerburnt.com/

Recording set up:
Database: PostgreSQL run locally in a docker container
SQL client: DBeaver https://dbeaver.io/
Microphone: Samson Q2U https://samsontech.com/products/micro...
Recording software: OBS https://obsproject.com/

Thank you for watching! Leave a comment below if you can think of any alternate solutions to today's problem, have suggestions for future videos, or just like to chat. Happy querying!

На этой странице сайта вы можете посмотреть видео онлайн All Ingredients Required | Intermediate SQL Problem длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Write a SQL Query 02 Апрель 2025, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 31 раз и оно понравилось 0 зрителям. Приятного просмотра!

310