add 1173

fishercoder1534 · fishercoder1534 · commit 447d73ac85b9 · 2020-01-30T21:13:59.000-08:00
diff --git a/README.md b/README.md
@@ -848,6 +848,7 @@ _If you like this project, please leave me a star._ &#9733;
 |1280|[Students and Examinations](https://leetcode.com/problems/students-and-examinations/)|[Solution](../master/database/_1280.sql) | [:tv:](https://www.youtube.com/watch?v=ThbkV4Fs7iE)| Easy |
 |1251|[Average Selling Price](https://leetcode.com/problems/average-selling-price//)|[Solution](../master/database/_1251.sql) | | Easy |
 |1179|[Reformat Department Table](https://leetcode.com/problems/reformat-department-table/)|[Solution](../master/database/_1179.sql) |  | Easy |
+|1173|[Immediate Food Delivery I](https://leetcode.com/problems/immediate-food-delivery-i/)|[Solution](../master/database/_1173.sql) |  | Easy |
 |1069|[Product Sales Analysis II](https://leetcode.com/problems/product-sales-analysis-ii/)|[Solution](../master/database/_1069.sql) |  | Easy |
 |1068|[Product Sales Analysis I](https://leetcode.com/problems/product-sales-analysis-i/)|[Solution](../master/database/_1068.sql) | | Easy |
 |627|[Swap Salary](https://leetcode.com/problems/swap-salary/)|[Solution](../master/database/_627.sql) | | Easy |
diff --git a/database/_1173.sql b/database/_1173.sql
@@ -0,0 +1,45 @@
+--1173. Immediate Food Delivery I
+--
+--Table: Delivery
+--+-----------------------------+---------+
+--| Column Name                 | Type    |
+--+-----------------------------+---------+
+--| delivery_id                 | int     |
+--| customer_id                 | int     |
+--| order_date                  | date    |
+--| customer_pref_delivery_date | date    |
+--+-----------------------------+---------+
+--delivery_id is the primary key of this table.
+--The table holds information about food delivery to customers that make orders at some date and specify a preferred delivery date (on the same order date or after it).
+--If the preferred delivery date of the customer is the same as the order date then the order is called immediate otherwise it's called scheduled.
+--
+--Write an SQL query to find the percentage of immediate orders in the table, rounded to 2 decimal places.
+--The query result format is in the following example:
+--Delivery table:
+--+-------------+-------------+------------+-----------------------------+
+--| delivery_id | customer_id | order_date | customer_pref_delivery_date |
+--+-------------+-------------+------------+-----------------------------+
+--| 1           | 1           | 2019-08-01 | 2019-08-02                  |
+--| 2           | 5           | 2019-08-02 | 2019-08-02                  |
+--| 3           | 1           | 2019-08-11 | 2019-08-11                  |
+--| 4           | 3           | 2019-08-24 | 2019-08-26                  |
+--| 5           | 4           | 2019-08-21 | 2019-08-22                  |
+--| 6           | 2           | 2019-08-11 | 2019-08-13                  |
+--+-------------+-------------+------------+-----------------------------+
+--
+--Result table:
+--+----------------------+
+--| immediate_percentage |
+--+----------------------+
+--| 33.33                |
+--+----------------------+
+--The orders with delivery id 2 and 3 are immediate while the others are scheduled.
+
+
+# Write your MySQL query statement below
+select round(
+    (
+    100 * (select count(*) from Delivery d where d.order_date = d.customer_pref_delivery_date)/
+        (select count(*) from Delivery)
+        ),
+    2) as immediate_percentage;
