Question: SQL database help customer (c_custkey, c_name, c_address, c_nationkey, c_phone, c_acctbal, c_mktsegment, c_comment) lineitem (l-orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extenderprice, l_discount, l_tax, l_returnflag, l_linestatus, l_shipdate, l_commitdate,
SQL database help
customer (c_custkey, c_name, c_address, c_nationkey, c_phone, c_acctbal, c_mktsegment, c_comment)
lineitem (l-orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extenderprice, l_discount, l_tax, l_returnflag, l_linestatus, l_shipdate, l_commitdate, l_receiptdate, l_shipinstruct, l_shipmode, l_comment)
nation (n_nationkey, n_name, n_regionkey, n_comment)
orders (o_orderkey, o_custkey, o_orderstatus, o_totalprice, o_orderdate, o_orderpriority, o_clerk, o_shippriority, o_comment)
part (p_partkey, p_name, p_mfgr, p_brand, p_type, p_size, p_container, p_retailprice, p_comment)
partsupp (p_spartkey, p_ssuppkey, p_savailqty, p_ssupplycost, p_scoment)
region (r_regionkey, r_name,r_comment)
supplier (s_suppkey, s_name, s_address, s_nationkey, s_phone, s_acctbal, s_comment)

1. Print the total amount of money (o.totalprice) spent on orders by each customer from FRANCE 2. Return the number of suppliers in each country. . How many orders are posted by customers in each country in EUROPE? How many parts with size below 20 does each supplier from BRAZIL sell? 5. Find the number of orders posted by each customer from GERMANY in 1995. 6. How many parts produced by each manufacturer (p_mfgr) are ordered at each order priority? 7. How many orders do customers in each country in ASIA have in each order status? 8. Print the number of orders completed in 1995 by the suppliers in each coumtry in AMERICA (see or ders.orderstatus; F stands for complete) 9. How many different clerks did the suppliers in RUSSIA work with? 10. Find the maximum discount for each type of items having ECONOMY in their type name. 1. Print the total amount of money (o.totalprice) spent on orders by each customer from FRANCE 2. Return the number of suppliers in each country. . How many orders are posted by customers in each country in EUROPE? How many parts with size below 20 does each supplier from BRAZIL sell? 5. Find the number of orders posted by each customer from GERMANY in 1995. 6. How many parts produced by each manufacturer (p_mfgr) are ordered at each order priority? 7. How many orders do customers in each country in ASIA have in each order status? 8. Print the number of orders completed in 1995 by the suppliers in each coumtry in AMERICA (see or ders.orderstatus; F stands for complete) 9. How many different clerks did the suppliers in RUSSIA work with? 10. Find the maximum discount for each type of items having ECONOMY in their type name
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
