Выведите всю информацию о товарах общего назначения (продуктовая линейка S).
SELECT *
FROM adventure.product
WHERE product_line = 'S';
Результат
| product_id |
name |
product_number |
finished_goods_flag |
color |
safety_stock_level |
reorder_point |
standard_cost |
list_price |
size |
size_unit_measure_code |
weight_unit_measure_code |
weight |
days_to_manufacture |
product_line |
class |
style |
product_subcategory_id |
sell_start_date |
sell_end_date |
discontinued_date |
update_date |
| 707 |
Sport-100 |
Helmet, |
Red |
HL-U509-R |
True |
Red |
4 |
3 |
13.0863 |
34.99 |
|
|
|
0 |
S |
|
31 |
2011-05-31 00:00:00 |
NaT |
2014-02-08 10:01:36.827000 |
|
| 708 |
Sport-100 |
Helmet, |
Black |
HL-U509 |
True |
Black |
4 |
3 |
13.0863 |
34.99 |
|
|
|
0 |
S |
|
31 |
2011-05-31 00:00:00 |
NaT |
2014-02-08 10:01:36.827000 |
|
| 711 |
Sport-100 |
Helmet, |
Blue |
HL-U509-B |
True |
Blue |
4 |
3 |
13.0863 |
34.99 |
|
|
|
0 |
S |
|
31 |
2011-05-31 00:00:00 |
NaT |
2014-02-08 10:01:36.827000 |
|
Задание выполнено верно