diff options
Diffstat (limited to 'graphs/sql/gluttonous_order/req04.sql')
| -rw-r--r-- | graphs/sql/gluttonous_order/req04.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/graphs/sql/gluttonous_order/req04.sql b/graphs/sql/gluttonous_order/req04.sql new file mode 100644 index 0000000..0967a4a --- /dev/null +++ b/graphs/sql/gluttonous_order/req04.sql @@ -0,0 +1,7 @@ +INSERT INTO public.scrooge_eats_basket_items ( order_id,item_id,quantity ) +SELECT DISTINCT 10000,I.id,1 +FROM +( + SELECT id FROM public.scrooge_eats_items + WHERE name SIMILAR TO '(Kinder Bueno White)|(Tacos)|(Coca-Cola)' +) AS I |