The course I'm taking is database management. I have attached the necessary information for question. I need the correct solution query for part A utilizing SUBQUERY. the query i have come up with isSELECT * FROM item_db WHERE unitprice > (SELECT unitprice FROM item_db WHERE item_code = '005');i get an empty set. how do i correct this so i dont receve an empty set? please provide query. thank you! Part A - Find items with a unit price greater than the unit price of the item with item code ‘005’. mysql> select * from item_db;| item_code | item_name | current_stock | unitprice |2B5 | 7100 |56 |40 |1045 |10 | 8300 |5 |33C250 |150 |855550 |650 |200 |1300 |15 |500 | 9300 |100 |7 rows in set (0.00 sec) mysql> select * from item_db;+-| item_code | item_name | current_stock | unitprice |2B5 | 710 | 833 | C855200 | 1500 | 97 rows in set (0.00 sec)100 |56 |40 |1045 |300 |5 |250 |150 |550 |650 |300 |15 |300 |100 |mysql> insert into item_db(item_code, item_name, current_stock, unitprice) values ('005', 13,52,908);ERROR 1406 (22001): Data too long for column 'item_name' at row 1mysql> select * from customer_db;+-| cust_id❘ cust_name | cust_hname | cust_street | cust_phone |2 | riya| 123abcI diablo8 | sean| 12345abc | tommy9 | riya| 123abc| diablo-+-44356798765 |4435673 rows in set (0.01 sec)mysql> SELECT * FROM item_db WHERE unitprice > (SELECT unitprice FROM item_db WHERE item_code = '005');Empty set (0.00 sec)

Subqueries, also called nested queries, are an effective feature in SQL that allows you to carry out…

Answered: The course I'm taking is database…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

The course I'm taking is database management.

I have attached the necessary information for question. I need the correct solution query for part A utilizing SUBQUERY. the query i have come up with is

SELECT * FROM item_db WHERE unitprice > (SELECT unitprice FROM item_db WHERE item_code = '005');

i get an empty set. how do i correct this so i dont receve an empty set? please provide query. thank you!

Part A - Find items with a unit price greater than the unit price of the item with item code ‘005’.

mysql> select * from item_db;
| item_code | item_name | current_stock | unitprice |
2B
5 | 7
100 |
56 |
40 |
1045 |
10 | 8
300 |
5 |
33
C
250 |
150 |
85
5
550 |
650 |
200 |
1
300 |
15 |
500 | 9
300 |
100 |
7 rows in set (0.00 sec)

mysql> select * from item_db;
+-
| item_code | item_name | current_stock | unitprice |
2B
5 | 7
10 | 8
33 | C
855
200 | 1
500 | 9
7 rows in set (0.00 sec)
100 |
56 |
40 |
1045 |
300 |
5 |
250 |
150 |
550 |
650 |
300 |
15 |
300 |
100 |
mysql> insert into item_db(item_code, item_name, current_stock, unitprice) values ('005', 13,52,908);
ERROR 1406 (22001): Data too long for column 'item_name' at row 1
mysql> select * from customer_db;
+-
| cust_id❘ cust_name | cust_hname | cust_street | cust_phone |
2 | riya
| 123abc
I diablo
8 | sean
| 12345abc | tommy
9 | riya
| 123abc
| diablo
-+-
443567
98765 |
443567
3 rows in set (0.01 sec)
mysql> SELECT * FROM item_db WHERE unitprice > (SELECT unitprice FROM item_db WHERE item_code = '005');
Empty set (0.00 sec)

Expert Solution

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions