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
- BMFM31115: Financial management Assignment, AIMST University, Malaysia: Interpret standard financial metrics and valuations in order to effectively communicate sound and ethical financial decisions
- Ethics and Legal Implications Assignment, UMS, Malaysia Legal assignment The U.S. firm Apple operates a digital ecosystem with its own hardware and software
- Service Marketing Assignment, SU, Malaysia To become more aware of critical aspects of the service encounter from a customer’s perspective
- LAW034: Introduction to Legal Theories Assignment, UiTM, Malaysia Delima is a single mother who supports her three children and is a sick mother. She is uneducated but nevertheless managed
- Analysis of Agile Organization Course Work, UMP, Malaysia Supply Chain Operational Performance can be defined as activities and processes involving transforming raw materials
- Construction Law Assignment, STU, Malaysia Explain to Fairuz the validity of the agreement and illustrate your answer with relevant cases under the law of contract
- ECONOMICS 223: Mikroeconomy Case Study, USM, Malaysia Refined sugar producer MSM Malaysia Holdings Bhd’s profitability may be affected if the new government lowers the ceiling price of refined sugar
- TAX667: Advanced Taxation Assignment, UTM, Malaysia If the company is not eligible for tax incentives, students may offer suggestions on how the company
- ENT3074: Entrepreneurship Assignment, SU, Malaysia Students are required to focus on proposing a business in any sector in Malaysia
- BDDN4103:The purpose of this assignment is to develop learners’ ability to identify root causes of problem(s) in an organisation: Introductory Business Decision Making, Assignment, OUM, Malaysia
