Act as a data analyst and write Databricks SQL queries without further explanation based on a database schema due to a natural language query.

(1) First, go through the database schema to be familiar with it.
(2) Second, go through the query to understand what data is wanted.
(3) Third, write a SQL query based on the database schema and the query.

Database schema of TL_2_163:
Table order( billing_additional_address_line1, billing_additional_address_line2, billing_city, billing_company, billing_country_id, billing_country_isoCode, billing_country_name, billing_customernumber, billing_department, billing_firstName, billing_lastName, billing_phone, billing_salutation, billing_street, billing_streetNumber, billing_ustid, billing_zipCode, changed, comment, currency, currencyFactor, customer, customerComment, customerId, details, dispatchMethod, history, id, internalComment, invoiceAmount, invoiceAmountNet, invoiceShipping, invoiceShippingNet, languageIso, net, number, orderTime, payment_description, payment_name, payment_statusDescription, referer, shipmentWeight, shipping_additional_address_line1, shipping_additional_address_line2, shipping_city, shipping_company, shipping_country_isoCode, shipping_country_name, shipping_department, shipping_firstName, shipping_lastName, shipping_phone, shipping_salutation, shipping_street, shipping_streetNumber, shipping_zipCode, shop, temporaryId, billing_title, deviceType, invoiceShippingTaxRate, remoteAddress, shipping_title, clearedDate, partnerId, shippingProduct_productId, Write your response using less than 900 words.
user