--please don't copy paste, other answer is wrong on chegg

//give sql queries based on following database

1. Find orders between a supplier and customer that are both from the same nation. Return customer ID followed by supplier name.

2. Find the suppliers who supply parts in ALL types of containers. Return the supplier name and number of container types it supplies.

3. Find all the suppliers who had customers in both UNITED STATES and CANADA. List the supplier IDs and names.

database--

Table name- (attributes)

NATION ( N_NATIONKEY ,N_NAME , N_REGIONKEY ,N_COMMENT )

REGION ( R_REGIONKEY, R_NAME ,R_COMMENT )

PART ( P_PARTKEY , P_NAME , P_MFGR , P_BRAND , P_TYPE , P_SIZE , P_CONTAINER , P_RETAILPRICE , P_COMMENT )

SUPPLIER ( S_SUPPKEY , S_NAME , S_ADDRESS , S_NATIONKEY , S_PHONE , S_ACCTBAL , S_COMMENT )

PARTSUPP ( PS_PARTKEY , PS_SUPPKEY , PS_AVAILQTY , PS_SUPPLYCOST , PS_COMMENT );

CUSTOMER ( C_CUSTKEY INTEGER NOT NULL, C_NAME VARCHAR(25) NOT NULL, C_ADDRESS VARCHAR(40) NOT NULL, C_NATIONKEY INTEGER NOT NULL, C_PHONE CHAR(15) NOT NULL, C_ACCTBAL DECIMAL(15,2) NOT NULL, C_MKTSEGMENT CHAR(10) NOT NULL, C_COMMENT VARCHAR(117) NOT NULL);

ORDERS ( O_ORDERKEY INTEGER NOT NULL, O_CUSTKEY INTEGER NOT NULL, O_ORDERSTATUS CHAR(1) NOT NULL, O_TOTALPRICE DECIMAL(15,2) NOT NULL, O_ORDERDATE DATE NOT NULL, O_ORDERPRIORITY CHAR(15) NOT NULL, O_CLERK CHAR(15) NOT NULL, O_SHIPPRIORITY INTEGER NOT NULL, O_COMMENT VARCHAR(79) NOT NULL);

LINEITEM ( L_ORDERKEY INTEGER NOT NULL, L_PARTKEY INTEGER NOT NULL, L_SUPPKEY INTEGER NOT NULL, L_LINENUMBER INTEGER NOT NULL, L_QUANTITY DECIMAL(15,2) NOT NULL, L_EXTENDEDPRICE DECIMAL(15,2) NOT NULL, L_DISCOUNT DECIMAL(15,2) NOT NULL,

L_TAX DECIMAL(15,2) NOT NULL, L_RETURNFLAG CHAR(1) NOT NULL, L_LINESTATUS CHAR(1) NOT NULL, L_SHIPDATE DATE NOT NULL, L_COMMITDATE DATE NOT NULL, L_RECEIPTDATE DATE NOT NULL, L_SHIPINSTRUCT CHAR(25) NOT NULL, L_SHIPMODE CHAR(10) NOT NULL, L_COMMENT VARCHAR(44) NOT NULL);