SQL Essentials Practice SQL Environment

SQL query  

Download the book SQL Essentials

Tables in the test database

customer customer_id, first_name, surname, date_of_birth, postcode

currency id, code, description

currexchange name, amount, exchdate

product id, product_code, currency_code, description

sample_list id, product_code

sample_list_ext id, product_code

transactions transaction_id, trans_date, customer_id, transaction_code, product_code, items, amount

Example SQL query: select * from customer