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
- ETR253E: TOURISM Report, KCC, Malaysia Choose one ENVIRONMENTAL IMPACTS (Examples: pollution, land degradation etc.) that caused by tourism industry and conduct an internet search on the impact that you have chosen
- LAW445: Malaysian Legal Principles Assignment, UiTM, Malaysia Students’ freedom of expression in social media has somehow been monitored by universities
- Animal Crossing Thesis, OUM, Malaysia The rationale of the study is to investigate the communicative competence of the English language among Malaysian adult players
- Business Law Assignment, TU, Malaysia AngTiong offered to sell his pharmacy to Zol for RM1 million via letter
- BAC3644: Taxation 2 Assignment, MMU, Malaysia Platina Jubilee Sdn. Bhd. was incorporated in Malaysia on 5th May 2017 with an authorized ordinary share capital
- Financial Accounting & Reporting Assignment, UUM, Malaysia Choose any three (3) accounting standards that you have learned in the class and discuss briefly about those standards
- Economics Assignment, UON, Malaysia Trade policy uncertainty in major economies increased to a historically high level in 2019 and has hardly been resolved
- LAW 437: Constitutional law Assignment, UTM, Malaysia Discuss critically the constitutional impact and significance of the following decided cases with special emphasis on the freedom of speech and expression
- BMHR5103: Human Resource Management Assignment, OUM, Malaysia Human resource management has a responsibility to ensure that the organization follows Occupational Safety and Health
- SBPH 1303 Applied Physics (Fizik Gunaan) Assignment Jan Sem 2026 | OUM
