Use QBE method with Access and data in the attached TAL Distributor database (above) to answer the following Queries:
1. List all the representatives in Pre table whose rate is greater than 0.08 in the descending.order of last name.(Simply query with a condition and sorting.)
2. List all the customers whose balance is greater $2,500 and credit limit is greater than $5,500.(Simply query with multiple conditions)
3. Find the total of the balances for all customers live in city of 'Fullton'. (Sum aggregate function with HAVING condition)
4. Delete the records from the OrderLine table for the Order Number equals 51625
Recently Asked Questions
- Does our state do enough to prevent distracted driving? How many sentences should a claim include when you present your argument essay?
- Chapter 10 – You are given the task of reducing your state’s correctional population by 10 percent by diverting offenders away from prison or releasing
- What is the purpose of the CSIRT and some of the team member roles?