SQL Essentials Test Environment



SQL query  






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