Large Order or Regular
Large Order or Regular
L. is flagging purchases that deserve a closer look in the journal. For every event where event_name = 'purchase', return event_id, revenue, and size: use крупный when revenue is greater than 2000 and обычный otherwise. Build the label with the compact two-branch conditional function.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| event_id | revenue | size |
|---|---|---|
| 3 | 1290 | обычный |
| 7 | 4300 | крупный |
| 10 | 890 | обычный |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid