How to Save Files - SQLite - IT Assignment Help

Assignment Task

Part-1(SQLite)
1. List Top 3 products based on QuantityAvailable. (productid, productname, QuantityAvailable ).
(3 Rows) [Note: Products]

2. Display EmailId of those customers who have done more than ten purchases. (EmailId, Total_Transactions).
(5 Rows) [Note: Purchasedetails, products]

3. List the Total QuantityAvailable category wise in descending order. (Name of the category,
QuantityAvailable)
(7 Rows) [Note: products, categories]

4. Display ProductId, ProductName, CategoryName, Total_Purchased_Quantity for the product which has been sold maximum in terms of quantity?
(1 Row) [Note: purchasedetails, products, categories]

5. Display the number of male and female customers in fastkart.
(2 Rows) [Note: roles, users]

6. Display ProductId, ProductName, Price and Item_Classes of all the products where Item_Classes are as follows:
If the price of an item is less than 2,000 then “Affordable”,
If the price of an item is in between 2,000 and 50,000 then “High End Stuff”,
If the price of an item is more than 50,000 then “Luxury”.
(57 Rows)

Part-2(MYSQL)
7. Write a query to display ProductId, ProductName, CategoryName, Old_Price(price) and New_Price as per the following criteria
a. If the category is “Motors”, decrease the price by 3000
b. If the category is “Electronics”, increase the price by 50
c. If the category is “Fashion”, increase the price by 150

For the rest of the categories price remains same.
Hint: Use case statement, there should be no permanent change done in table/DB.
(57 Rows)

[Note: products, categories]

8. Display the percentage of females present among all Users. (Round up to 2 decimal places)
Add “%” sign while displaying the percentage.
(1 Row)

[Note: users]
9. Display the average balance for both card types for those records only where CVVNumber > 333 and NameOnCard ends with the alphabet “e”.
(2 Rows) [Note: carddetails]

This IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.