My Portfolio

Search This Blog

Advanced Excel Course

on January 16, 2024

Get link
Facebook
X
Pinterest
Email
Other Apps

Successfully completed an course on Advanced Excel with Amity University.

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Linkedin Profile Link

My Linkedin Profile : - Linkedin Profile

SQL Project : Downloaded Pizza sales dataset from www.kaggle.com 1. Total revenue from pizzas sold SQL query used :- Select SUM(total_price) AS Total_revenue from Pizza_sales; 1. Total quantity of pizzas sold SQL Query used is:- Select SUM(quantity) AS Total_pizza_sold from Pizza_sales; 1. How many unique customer orders were made. SQL Query used is:- Select count(distinct order_id) As Unique_customers from Pizza_sales; 1. Find out the average order value SQL Query used is:- Select sum(total_price)/count(distinct order_id) as average_order_value from Pizza_sales ; 5. Find the daily trends of Sales of pizza SQL Query used is:- Select DATENAME(DW, order_date) as order_day, COUNT(DISTINCT order_id) as Total_oders from Pizza_sales; GROUP BY DATENAME(DW,order_date); 5. ...

Powered by Blogger

Theme images by Petrovich9

Advanced Excel Course

Comments

Post a Comment