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
- BTW3153: Malaysian income tax law Case Study, MUM, Malaysia The student has to imagine that this request comes from a client, a partner in an accounting firm, or the manager of the company
- OUMH1603: Learning Skills for 21st Century Assignment, OUM, Malaysia Demonstrate Critical Thinking and Creative Thinking. Use your critical thinking and reasoning skills to solve the following problem
- General information about the organization (Short company profile. May include Vision, Mission: Strategic Human Resources Management Assignment, SU, Malaysia
- TBE103/03: Environmental Science and Design Report, WOU, Malaysia Green and sustainable development is globally promoted, and “Go Green” initiatives are also widely being encouraged in the country
- MAT455: Further Calculus for Engineers Assignment, UiTM, Malaysia Plot the region using the mathematical application and Evaluate the given integral
- Managing Organizations Case Study, UUM, Malaysia On a hot and dry afternoon in May 2014, Shiekh Farrukh Niaz, chief executive officer and owner of Pak Sweets
- KT24403: Operating Systems Assignment, UMS, Malaysia There are N philosophers and N forks, the philosophers represent processes and forks represent resources
- Commercial Law Essay, UKM, Malaysia Examining the Influence of Existing Regulation on the Increase of Electricity Theft due to Cryptocurrency Mining
- ELC101: Introduction to Instrumentation Case Study, DTCC, Malaysia The reasoning found in the judgments of the Lord’s Justices of Appeal is fairly consistent. All three agree
- GHZM2023: Tourism Marketing Case Study, UUM, Malaysia Do you think charging a levy of USD10 for every tourist visiting Bali would be sufficient to dissuade visits to the island
