compatibilitygood first issue
Metriche repository
- Star
- (19.103 star)
- Metriche merge PR
- (Metriche PR in attesa)
Descrizione
More in the saga of the new testing database ™️
For the following query:
select u.first_name, p.name, o.status, r.rating
from users u
inner join orders o on u.id = o.user_id and o.status in ('shipped', 'delivered')
left join order_items oi on o.id = oi.order_id
inner join products p on oi.product_id = p.id and p.price > 50
left join reviews r on p.id = r.product_id and r.user_id = u.id and r.rating >= 4
where u.age between 25 and 35
limit 10;
SQLite returns:
Shawn|shorts|delivered|
Vanessa|accessories|shipped|
Felicia|sweatshirt|shipped|
turso returns:
Vanessa|accessories|shipped|
Shawn|shorts|delivered|
Felicia|sweatshirt|shipped|