【小练习】SQL_OR

最新推荐文章于 2024-07-18 15:32:08 发布

数星星的小贝壳

最新推荐文章于 2024-07-18 15:32:08 发布

阅读量206

点赞数 1

分类专栏：小练习 SQL 文章标签： SQL OR

本文链接：https://blog.csdn.net/leledexixi/article/details/81048733

版权

SQL 同时被 2 个专栏收录

21 篇文章 0 订阅

订阅专栏

小练习

14 篇文章 0 订阅

订阅专栏

Find list of orders ids where either gloss_qty or poster_qty is greater than 4000. Only include the id field in the resulting table.
Write a query that returns a list of orders where the standard_qty is zero and either the gloss_qtyor poster_qty is over 1000.
Find all the company names that start with a 'C' or 'W', and the primary contact contains 'ana' or 'Ana', but it doesn't contain 'eana'.

1
SELECT id
FROM orders
WHERE gloss_qty > 4000 OR poster_qty > 4000;

2
SELECT *
FROM orders
WHERE standard_qty = 0 AND (gloss_qty > 1000 OR poster_qty > 1000);

3
SELECT name
FROM accounts
WHERE (name LIKE 'C%' OR name LIKE 'W%') AND (primary_poc LIKE '%ana%' OR primary_poc LIKE '%Ana%') AND primary_poc NOT LIKE '%eana%' ;