Skip to content

dm-zhuk/goit-rdb-hw-05

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 

Repository files navigation

goit-rdb-hw-05 Relationship Databases Topic V Nested requests. Code reuse

-- Task 1. SQL query that displays the order_details table and the customer_id field from the orders table, respectively, for each record field from the order_details table

screenshot

-- Task 2. SQL query that displays the order_details table. The results are filtered so that the corresponding record from the orders table fulfils the condition shipper_id=3. A nested query in the WHERE clause used

screenshot

-- Task 3. SQL query nested in the FROM' statement, which selects rows with the quantity>10' condition from the order_details table.

screenshot

-- Task 4: Solution for task 3 using the WITH statement to create the temporary table temp

screenshot

-- Task 5: This function has two parameters that divide the first parameter by the second. Both the parameters and the return value are of FLOAT type. The DROP FUNCTION IF EXISTS construct applied to the quantity attribute of the order_details table

screenshot

text

About

Relationship Databases Topic V Nested requests. Code reuse

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published