Please write a query for dvdrental database. Please list first names of customers starting with letter L. Include only first names, remove duplicated rows. Please sort rows by first name. postgres

Please help and break down all the steps I should take in order to succesfully complete the query. Create the following query in access: a. The company has been informed that the tax has been increased to 17.5%. Calculatehow much additional tax (i.e., the difference) the store would have collected by year.Name this query Q3 – ADDED-TAX.

Update table purchaseOrder, set column orderStateld equal to subquery a. (select column id from table orderstate where state equals "Payment sent") 3 Alter table supplierTransaction add column paymentDate as data type date, not null, default value of (CURRENT_DATE) (Note: the parenthesis MUST be included) Insert into table supplierTransaction, columns purchaseOrderId and total result set returned from query a. Select columns id and total from table purchaseOrder where column orderStateld is equal to subquery i. (select column id from table orderState where column state is equal to "Payment sent") Write Test Case 2 as a SQL join query to do the following a. Select supplierName from table supplier as Supplier b. Select purchaseOrderld from table supplierTransaction as “Purchase Order" c. Select description from table product as Product d. Select total from table purchaseOrder as “Product Total" e. Join tables şupplierTransaction, purchaseOrder, supplier, product f. Order by column…

Write a query to list the details of all authors born in the decade of the 1980s.