-- Database schema
| Customers : customer_id [ INT ] primary_key , customer_first_name [ TEXT ] , customer_middle_initial [ TEXT ] , customer_last_name [ TEXT ] , gender [ TEXT ] , email_address [ TEXT ] , login_name [ TEXT ] , login_password [ TEXT ] , phone_number [ TEXT ] , town_city [ TEXT ] , state_county_province [ TEXT ] , country [ TEXT ] | Orders : order_id [ INT ] primary_key , customer_id [ INT ] Orders.customer_id = Customers.customer_id , date_order_placed [ TEXT ] , order_details [ TEXT ] | Invoices : invoice_number [ INT ] primary_key , order_id [ INT ] Invoices.order_id = Orders.order_id , invoice_date [ TEXT ] | Accounts : account_id [ INT ] primary_key , customer_id [ INT ] Accounts.customer_id = Customers.customer_id , date_account_opened [ TEXT ] , account_name [ TEXT ] , other_account_details [ TEXT ] | Product_Categories : production_type_code [ TEXT ] primary_key , product_type_description [ TEXT ] , vat_rating [ INT ] | Products : product_id [ INT ] primary_key , parent_product_id [ INT ] , production_type_code [ TEXT ] Products.production_type_code = Product_Categories.production_type_code , unit_price [ INT ] , product_name [ TEXT ] , product_color [ TEXT ] , product_size [ TEXT ] | Financial_Transactions : transaction_id [ INT ] , account_id [ INT ] Financial_Transactions.account_id = Accounts.account_id , invoice_number [ INT ] Financial_Transactions.invoice_number = Invoices.invoice_number , transaction_type [ TEXT ] , transaction_date [ TEXT ] , transaction_amount [ INT ] , transaction_comment [ TEXT ] , other_transaction_details [ TEXT ] | Order_Items : order_item_id [ INT ] primary_key , order_id [ INT ] Order_Items.order_id = Orders.order_id , product_id [ INT ] Order_Items.product_id = Products.product_id , product_quantity [ TEXT ] , other_order_item_details [ TEXT ] | Invoice_Line_Items : order_item_id [ INT ] Invoice_Line_Items.order_item_id = Order_Items.order_item_id , invoice_number [ INT ] Invoice_Line_Items.invoice_number = Invoices.invoice_number , product_id [ INT ] Invoice_Line_Items.product_id = Products.product_id , product_title [ TEXT ] , product_quantity [ TEXT ] , product_price [ INT ] , derived_product_cost [ INT ] , derived_vat_payable [ INT ] , derived_total_cost [ INT ] |
-- -- Show the id, the date of account opened, the account name, and other account detail for all accounts.

SELECT account_id ,  date_account_opened ,  account_name ,  other_account_details FROM Accounts;