Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Oppiskele Challenge In Statement | Database and Nested Queries
Data Manipulation using SQL

book
Challenge In Statement

Tehtävä

Swipe to start coding

Create a query to find all songs' titles (title) under $200 (column price), where the singer is one of them (naming): ('Britney Spears', 'Pink Floyd', 'ABBA'). Use IN statement.

Ratkaisu

SELECT title
FROM songs
WHERE price < 200 AND singer_id IN (
SELECT id
FROM singers
WHERE naming IN ('ABBA', 'Britney Spears', 'Pink Floyd')
)

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 1. Luku 3
SELECT _ _ _
FROM _ _ _
WHERE _ _ _
Query ResultQuery Result
No query executed yet...

Kysy tekoälyä

expand
ChatGPT

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

some-alt