2- Consider a database with 3 tables (order-invoice-customer)
a. Write a SQL query that lists all orders for a customer whose First Name is John and last name Paul and that exceed a value of $100,000

b. Write a SQL query that lists all custmors who placed an order in 2016. Consider that date column is in the following format: yyy-mm-dd

Question

2-  Consider a database with 3 tables (order-invoice-customer)
      a. Write a SQL query that lists all orders for a customer whose First Name is John and last name Paul and that exceed a value of $100,000

     b. Write a SQL query that lists all custmors who placed an order in 2016. Consider that date column is in the following format: yyy-mm-dd

Tangerine Software

Pergunta de entrevista da empresa Tangerine Software

Empresas seguidas

Buscas de vagas