Using SQL to manipulate and clean the data, analyzing to discover trends and patterns, dig insights in an understandable format.
The fields present in Items dataset are,
1. id 2. Order_id 3. Name 4. Is_veg/not The fields present in Orders dataset are,
1. id 2. order_id 3. order_Total 4. restaurent name 5. order_time 6. rain_mode 7. on_time 
95 unique orders are placed according to this dataset.
There are 3 modes namely -Heavy,moderate,drizzle with 0,2 and 5 as it's respective identifiers from the dataset.
There are 49 unique restaurents name present in the order history in the given dataset.
The Bowl company is the restaurent which holds the highest number of orders according to the swiggy customers present in the dataset. from the above results we can also categorize the restaurents as most favourite , favourite and least favourite by which required recommendations can be activated by the company to attract its customer to place an order.
From the above result, 2021, October holds the highest number of Orders.
From the above results we can conclude that October month has generated the highest revenue and March month has generated least revenue, considering this more discounts and offers can be included during the least revenue months to bosst up the sales.
There are 164 unique items.
Classic Mac & cheese is the most ordered item.
A. There are 180 veg items
B. There are 12 non veg items
C. There is 1 undefined category item
Here the undeifined category can be considered as Desserts.
There are 10 chicken based dishes present in our dataset.
There are 4 paratha items present in the dataset.
2 items are atleast placed in any order according to the given dataset.
Corn & Cheddar Quesadilla & Garlic Bread With Cheese Corn & Peas Sub ( 15 cm, 6 Inch ) & Paneer Tikka Sub ( 15 cm, 6 Inch ) Corn & Peas Sub (15 cms, 6 Inch) & Paneer Tikka Sub (15 cms, 6 Inch) Corn & Peas Sub (15 cms, 6 Inch) & Paneer Tikka Sub (15 cms, 6 Inch) Crunchy Chicken & Paneer & corn Pasta Daily Special Side Dish (Portion) & Phulka Chapati Desi Dal Tadka with Jeera Rice & Nawabi Paneer Lababdar with Matar Pulao Desi Dal Tadka with Jeera Rice & Triple Ripple Death by Chocolate Dragon Chicken & Gobi Manchurian (Dry) Dragon Chicken & Paneer Fried Rice Farmhouse & Golden Corn Fries (R) & Mcflurry Oreo Small Fries (R) & McSpicy Paneer Burger Fries (R) & New Chocolate Chip Muffin Fries (R) & Snack box Garlic Naan & Gobi Masala Garlic Naan & Paneer Pulao Garlic Naan & Strawberry Milk Shake Ghee Paneer Masal Dosa & Kadai Paneer Ghee Paneer Masal Dosa & Masala Kulcha Ghee Paneer Masal Dosa & Phulka Ghee Paneer Masal Dosa & Sambar Idli Ghee Paneer Masal Dosa & Seven Taste Uttapam Gobi Manchurian & Paneer Biryani Gobi Manchurian & Paneer Pulao Gobi Manchurian & Paneer Pulao with Kadhi Gobi Manchurian & Phulka Gobi Manchurian (Dry) & Paneer Fried Rice Gobi Manchurian Dry & Paratha Kuruma Gobi Masala & Paneer Pulao Gobi Masala & Strawberry Milk Shake Golden Corn & Paneer & Onion Good ol' Rajma Chawal & Paneer Butter Masala with Mattar Pulao Good ol' Rajma Chawal & Peri Peri Chicken with Egg Corn Rice Hazelnut (Baby) & Strawberry (Baby) Hazelnut Brownie & Jumbo Paneer Chole Wrap Hazelnut Brownie & Paneer Signature Rice Bowl (Mini) Hazelnut Brownie & Rajma Masala Rice Bowl (Mini) Hazelnut Brownie & Super Saver Paneer Rice Bowl Meal Idli (2 Pcs) & Poori Masala Jumbo Paneer Chole Wrap & Paneer Signature Rice Bowl (Mini) Jumbo Paneer Chole Wrap & Rajma Masala Rice Bowl (Mini) Kadai Paneer & Masala Kulcha Kadai Paneer & Phulka Kadai Paneer & Sambar Idli Kadai Paneer & Seven Taste Uttapam Maggi Italiano & Mexican Fries (Chef Suggested) Mango Mastani & Pomegranate Juices Masala Kulcha & Mixed Vegetable Raita Masala Kulcha & Onion Aloo Mixed Paratha Masala Kulcha & Phulka Masala Kulcha & Sambar Idli Masala Kulcha & Seven Taste Uttapam MASALA PURI & SEV PURI Mattar Paneer & Punjabi Chaach Di-Bottle (Butter Milk) Mattar Paneer & Tawa Ghee Phulka McEgg Meal ( R ) & Mexican McAlooTikki Burger Mcflurry Oreo Small & McSpicy Paneer Burger Mcflurry Oreo Small & New Chocolate Chip Muffin Mcflurry Oreo Small & Snack box McSpicy Paneer Burger & New Chocolate Chip Muffin McSpicy Paneer Burger & Snack box Mixed Veg Raita & Peas Pulao Mixed Vegetable Raita & Onion Aloo Mixed Paratha Naan & Paneer Tikka Masala Naan & Roti Nawabi Paneer Lababdar Parotta Bowl & Paneer 65 with Chilli Garlic Fried Rice Nawabi Paneer Lababdar Parotta Bowl & Sprite Can (300 ml) Nawabi Paneer Lababdar Parotta Bowl & Triple Ripple Death by Chocolate Nawabi Paneer Lababdar with Matar Pulao & Triple Ripple Death by Chocolate New Chocolate Chip Muffin & Snack box Oreo Brownie & Trio of Chocolate Jar Oreo Cream and Fudge & Swiss Chocolate Ice cream Palak Paneer Bread Kulcha Lunchbox & Palak Paneer Jumbo Lunchbox Palak Paneer Bread Kulcha Lunchbox & Red Velvet Lava Cake Palak Paneer Jumbo Lunchbox & Red Velvet Lava Cake Paneer 65 with Chilli Garlic Fried Rice & Sprite Can (300 ml) Paneer 65 with Chilli Garlic Fried Rice & Triple Ripple Death by Chocolate Paneer Butter Masala with Mattar Pulao & Peri Peri Chicken with Egg Corn Rice Paneer Pulao & Phulka Paneer Pulao & Strawberry Milk Shake Paneer Signature Rice Bowl (Mini) & Rajma Masala Rice Bowl (Mini) Paneer Tikka Masala & Roti Penne Arrabiata Pasta La Vista & Pind Di Daal Makhani with Jeera Rice Phulka & Sambar Idli Phulka & Seven Taste Uttapam Poori Masala & Uttapam Punjabi Chaach Di-Bottle (Butter Milk) & Tawa Ghee Phulka Rasmalai & Veg Pulao with Raita Sambar Idli & Seven Taste Uttapam Schezwan Paneer Frankie & Tawa Paneer Frankie Sprite Can (300 ml) & Triple Ripple Death by Chocolate 
There are 171 item combos present in the dataset.