Answer:
SELECT product_name, SUM(DISTINCT quantity) AS total_quantity
RANK() OVER (PARTITION BY total_quantity ORDER BY product_name) AS rank,
DENSE_RANK () OVER (ORDER BY quantity DESC) AS dense_rank
FROM Order_items
JOIN products ON Order_items.product_id = products.product_id
GROUP BY product_id
Explanation:
The SQL query returns four columns namely, product name, total quantity, rank and dense rank. The query uses the rank and the dense rank function to return the rows according to numeric ranks.
Answer:
def main():
principal = float(input("Enter the amount of principal amount to be deposited: "))
rate = float(input("Enter annual interest rate paid by the account: "))
num = int(input("Enter the number of times per year that the interest is compunded: "))
years = float(input("Enter the number of years the account will be left to earn interest: "))
amount = principal*(1+(rate*.01)/num)**(num*years)
print("The amount of money will be in the account after ", years, "years:", round(amount,2))
main()
Explanation:
- Calculating the balance of the account after a specified number of years with the help of the formula:
- amount = principal*(1+(rate*.01)/num)**(num*years)
The answer to your question is software.
Answer:
A merchant is a person who buys or sells goods in large quantities, especially one who imports and exports them.
