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
- DHT 541: Tourism and Hospitality Economics Assignment, CUM, Malaysia Tourism is the generic term to cover both demand and supply that has been adopted in various forms and used
- The Effect Of Traditional Classroom Management On Student Performance In An Ib Myp Classroom: Education, Research Paper, Malaysia
- Management and Leadership in Education Assignment, UPM, Malaysia Ms. Sara is a principal at a secondary school in Malaysia who has noticed that her teachers seem stressed and overwhelmed
- Company law Assignment, UCISS, Malaysia This government has moved quickly to strengthen our response to Putin’s cronies and ensure that corrupt elites
- STA60104 Quantitative Methods for Business Assignment Malaysia
- MAT455: Further Calculus for Engineers Assignment, UiTM, Malaysia Plot the region using the mathematical application and Evaluate the given integral
- FIT1047: User input (4 points) The next step is to implement a subroutine that reads a string, character by character: Introduction to computer systems, networks and security Assignment, MU, Malaysia
- MBA7313: As a strategist or the individual who is responsible for the success or failure of an organization: Strategic Management Assignment, UTM, Malaysia
- PHYSIOTHERAPY Assignment, MU, Malaysia Mrs. Spoon is a 48-year-old woman who works part-time as a kindergarten assistant come to physiotherapy clinic with the history of Pain
- XBMB3104: MICROBIOLOGY Assignment, OUM, Malaysia you are appointed to give a briefing on the tiers of recommended precautions to prevent the spread of infections in healthcare settings
