Выведите всю информацию о товарах для туризма (продуктовая линейка T).
SELECT *
FROM adventure.product
WHERE product_line = 'T';
Результат
| 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 |
| 821 |
Touring Front Wheel |
FW-T905 |
True |
Black |
500 |
375 |
96.7964 |
218.01 |
1 |
T |
17 |
2012-05-30 00:00:00 |
2013-05-29 00:00:00 |
2014-02-08 10:01:36.827000 |
|
|
|
|
|
|
|
| 829 |
Touring Rear Wheel |
RW-T905 |
True |
Black |
500 |
375 |
108.784 |
245.01 |
1 |
T |
17 |
2012-05-30 00:00:00 |
2013-05-29 00:00:00 |
2014-02-08 10:01:36.827000 |
|
|
|
|
|
|
|
Задание выполнено верно