@example.com', '+919876543212', 4.2);

INSERT INTO Customers (name, email, phone)
VALUES
('Alice Brown', '[alice.brown@example.com](mailto:alice.brown@example.com)', '+919876543213'),
('Bob Green', '[bob.green@example.com](mailto:bob.green@example.com)', '+919876543214'),
('Charlie Lee', '[charlie.lee@example.com](mailto:charlie.lee@example.com)', '+919876543215');

INSERT INTO Routes (route\_name)
VALUES
('Chennai Central to Anna Nagar'),
('Chennai Airport to Tambaram'),
('Chennai Central to OMR');

INSERT INTO Customer\_Requests (customer\_id, pickup\_location, destination, travel\_date, travel\_time, status)
VALUES
(1, 'Chennai Central', 'Anna Nagar', '2023-03-01', '10:00:00', 'Pending'),
(2, 'Chennai Airport', 'Tambaram', '2023-03-02', '14:00:00', 'Pending'),
(3, 'Chennai Central', 'OMR', '2023-03-03', '12:00:00', 'Pending'),
(1, 'Anna Nagar', 'Chennai Central', '2023-03-04', '11:00:00', 'Pending'),
(2, 'Tambaram', 'Chennai Airport', '2023-03-05', '09:00:00', 'Pending'),
(3, 'OMR', 'Chennai Central', '2023-03-06', '10:00:00', 'Pending');

INSERT INTO Bookings (request\_id, vehicle\_id, driver\_id, start\_time, end\_time, distance, fare)
VALUES
(1, 1, 1, '2023-03-01 10:00:00', '2023-03-01 11:00:00', 10.5, 200),
(2, 2, 2, '2023-03-02 14:00:00', '2023-03-02 15:00:00', 15.0, 300),
(3, 3, 3, '2023-03-03 12:00:00', '2023-03-03 13:00:00', 20.0, 400),
(4, 1, 1, '2023-03-04 11:00:00', '2023-03-04 12:00:00', 10.5, 200),
(5, 2, 2, '2023-03-05 09:00:00', '2023-03-05 10:00:00', 15.0, 300),
(6, 3, 3, '2023-03-06 10:00:00', '2023-03-06 11:00:00', 20.0, 400);

Displaying Data
---------------

To display the most frequently booked route in Chennai, we can use the following query:
```vbnet
SELECT pickup_location, destination, COUNT(*) as count
FROM Customer_Requests
WHERE status = 'Accepted'
GROUP BY pickup_location, destination
ORDER BY count DESC
LIMIT 1;
```
This query will give us the pickup location, destination, and the count of the number of times this route has been booked. We are only selecting the routes that have been accepted, and we are sorting the results in descending order of the count. We are also limiting the results to one row, which will give us the most frequently booked route.

To display the number
example.com', '+919876543212', 4.2);INSERT INTO Customers(이름, 이메일, 전화)VALUES('Alice Brown', '[alice.brown@example.com](mailto:alice.brown@example.com)', '+919876543213'),('Bob Green', '[bob.green@example.com](mailto:bob.green@example.com)', '+919876543214'),('Charlie Lee', '[charlie.lee@example.com](mailto:charlie.lee@example.com)', '+919876543215');INSERT INTO Routes (route\_name)VALUES('첸나이 센트럴에서 안나가르까지'),('첸나이 공항~탐바람'),('첸나이 센트럴에서 OMR까지');고객\_요청에 삽입 (고객\_id, 픽업\_위치, 목적지, 여행\_날짜, 여행\_시간, 상태)VALUES(1, '첸나이 센트럴', '안나가르', '2023-03-01', '10:00:00', 'Pending'),(2, 'Chennai Airport', 'Tambaram', '2023-03-02', '14:00:00', 'Pending'),(3, 'Chennai Central', 'OMR', '2023-03-03', '12:00:00', 'Pending'), (1, 'Anna Nagar', '14:00:00', 'Pending'),(1, 'Anna Nagar', 'Chennai Central', '2023-03-04', '11:00:00', 'Pending'),(2, 'Tambaram', 'Chennai Airport', '2023-03-05', '09:00:00', 'Pending'), (3, 'OMR', '11:00:00', 'Pending'),(3, 'OMR', 'Chennai Central', '2023-03-06', '10:00:00', 'Pending'), (3, 'OMR', 'Chennai Central', '2023-03-06', '10:00:00', 'Pending');예약에 삽입 (요청\_id, 차량\_id, 운전자\_id, 시작\_시간, 종료\_시간, 거리, 요금)VALUES(1, 1, 1, '2023-03-01 10:00:00', '2023-03-01 11:00:00', 10.5, 200),(2, 2, 2, '2023-03-02 14:00:00', '2023-03-02 15:00:00', 15.0, 300),(3, 3, 3, '2023-03-03 12:00:00', '2023-03-03 13:00:00', 20.0, 400),(4, 1, 1, '2023-03-04 11:00:00', '2023-03-04 12:00:00', 10.5, 200),(5, 2, 2, '2023-03-05 09:00:00', '2023-03-05 10:00:00', 15.0, 300),(6, 3, 3, '2023-03-06 10:00:00', '2023-03-06 11:00:00', 20.0, 400);데이터 표시---------------첸나이에서 가장 자주 예약된 노선을 표시하려면 다음 쿼리를 사용할 수 있습니다:```vbnetSELECT pickup_location, destination, COUNT(*) as countFROM Customer_RequestsWHERE status = 'Accepted'GROUP BY pickup_location, destinationORDER BY count DESCLIMIT 1;```이 쿼리는 픽업 위치, 목적지 및 이 경로가 예약된 횟수를 제공합니다. 수락된 경로만 선택하며, 카운트 내림차순으로 결과를 정렬합니다. 또한 결과를 한 행으로 제한하여 가장 자주 예약된 경로를 표시합니다.숫자를 표시하려면 다음과 같이 하세요.