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. Please provide solution in detail so i can better understand why. I need solution query for part A and B utilizing SUBQUERY. Thank you in Advance!

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

Part B - Display all orders placed by customers from ‘curryst’. i.e., Customer Street should be
'curryst'.

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 customer_db;
+-
| cust_id❘ cust_name | cust_hname | cust_street | cust_phone |
2 | riya
8 | sean
| 123abc
|12345abc
| 123abc
| diablo
| tommy
diablo
9 | riya
-+-
3 rows in set (0.01 sec)
443567 |
98765 |
443567

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

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