Write SQL queries to answer the following questions. Use the information given in each table: Database Assignment, IIU, Malaysia
| University | INTI International University (IIU) |
| Subject | Database Assignment |
1. Write SQL queries to answer the following questions. Use the information given in each table.
a) List the customer details who has a balance of more than 300.
b) List the customer’s name, area code, and invoice number of all customers. Sort the answer in descending order by customer name.
C) List the male customer details whose name starts with the letter
d) Find the number of male customers and display the column name as ‘Total
e) Find the minimum, maximum, average, and number of customers for each area code.
f) Change the balance for Siti to 500.
g) Find the name of a customer who lives in the same area as Diana.
2. Consider the structure of the following PRODUCT table.
a) Write the SQL command to create a new table called PRODUCT based on the information given in Table 1 below.
b) Change the field length of the description to VARCHAR(30) in the PRODUCT table.
c) Add a price column in between description and code in the PRODUCT table. This column only allows floating number data to be entered with a maximum precision of 3 digits and a scale of 2 digits.
d) Rename column description to in the PRODUCT table. This column only
allows variable character data to be entered with a maximum of 30 characters.
Get Help By Expert
Need help with your Data Assignment in Malaysia? Look to our assignment helper Malaysia service, where Malaysian students can conveniently pay someone to do my assignment and receive personalized support. Our team of experts is adept at handling various data-related tasks, including analysis, modelling, and programming.
Recent Solved Questions
- BGN352: Building Law Assignment, UiTM, Malaysia English Law plays an important part in the Malaysian legal system and Explain the application of English Law as a source
- MX3536: Differential Equations Assignment, UTM, Malaysia Concider the heat equation with boundary conditions and initial conditions
- Cross-Cultural Management Assignment Report: Importance, Challenges & Strategies in Global Teams
- Fundamentals of Finance Assignment, MUM, Malaysia PYG Berhad inventory is held on average for 50 days, account receivable is collected in 20 days, and account payable
- TEE103: (a) Determine the equivalent resistance for circuits in Figure 1 below: Circuit Theory I Assignment: WOU, Malaysia
- TBE103/03: Environmental Science and Design Report, WOU, Malaysia The elements of the environmental design have played major roles in providing comfort to the occupants of a building
- Business Law Course Work, TU, Malaysia Lim agreed to sell to Ricky his house “Awesome Villa” on Tioman Island at the prevailing market value. Before the contract was signed
- BNBS 6114: Communication and Counselling Essay, LUC, Malaysia Communication is vital in improving health outcomes. Due to the new challenges posed by the COVID-19 pandemic
- CT108-3-1 Python Programming (PYP) Assignment, APU, Malaysia Groceries Management System (GMS) Due to busy schedule, most of us prefer online shopping even to buy groceries and household items
- MGT7101: Managing Operations of Business Assignment, PBS, Malaysia A brief introduction of the organization, with a general discussion on its service offering and industry
