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)

SQL database help customer (c_custkey, c_name, c_address, c_nationkey, c_phone, c_acctbal, c_mktsegment, c_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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!