Question

На языке DDL Написать простые запросы 1. Вывести все данные о клиентах.2. Вывести ФИО клиентов, у которых не указан телефон.3. Вывести код штрафа, имеющего сумму не более5000 руб. Отсортировать по убыванию суммы.4. Вывести без дублирования коды штрафов, зафиксированных в авариях.5. Вывести код автомобиля с кодом марки 2 или 5 и годом выпуска не позднее 2012 г.6. Вывести код автомобиля с кодом типа 2 или 4 и кодом марки 1 или 3 и годом выпуска 2012.7. Вывести код автомобиля с кодом типа 2 или 4 и годом выпуска 2012 или 2014 и стоимостью менее 500000 или с кодом тип 1 или 3 и годом выпуска 2016.8. Вывести данные о выданных автомобилях, у которых, дата выдачи не 21.02.2018 г. или не 01.04.2018 г., дата возврата с 30.02.2018 по 30.01.2018, а скидка не составляет от 500 руб. до 1000 руб.​

Answer 1

Ответ:

dapat May a or b ganga Walla naman

Answer 2

Writing Simple Queries in DDL

To write simple queries in DDL (Data Definition Language), you can use SQL to retrieve specific data from a database. Here are the queries based on the provided requirements:

1. Retrieve all data about clients: ``` SELECT * FROM clients; ```

2. Retrieve the full names of clients who do not have a phone number specified: ``` SELECT full_name FROM clients WHERE phone_number IS NULL; ```

3. Retrieve the penalty code with a sum not exceeding 5000 rubles, sorted by descending sum: ``` SELECT penalty_code FROM penalties WHERE penalty_amount <= 5000 ORDER BY penalty_amount DESC; ```

4. Retrieve unique penalty codes recorded in accidents without duplication: ``` SELECT DISTINCT penalty_code FROM accidents; ```

5. Retrieve the car code with a brand code of 2 or 5 and a production year not later than 2012: ``` SELECT car_code FROM cars WHERE brand_code IN (2, 5) AND production_year <= 2012; ```

6. Retrieve the car code with a type code of 2 or 4 and a brand code of 1 or 3 and a production year of 2012: ``` SELECT car_code FROM cars WHERE type_code IN (2, 4) AND brand_code IN (1, 3) AND production_year = 2012; ```

7. Retrieve the car code with a type code of 2 or 4 and a production year of 2012 or 2014 and a cost less than 500,000 or with a type code of 1 or 3 and a production year of 2016: ``` SELECT car_code FROM cars WHERE (type_code IN (2, 4) AND production_year IN (2012, 2014) AND cost < 500000) OR (type_code IN (1, 3) AND production_year = 2016); ```

8. Retrieve data about issued cars where the issue date is not on 21.02.2018 or 01.04.2018, the return date is from 30.02.2018 to 30.01.2018, and the discount is not between 500 and 1000 rubles: ``` SELECT * FROM issued_cars WHERE (issue_date NOT IN ('21.02.2018', '01.04.2018') AND return_date BETWEEN '30.02.2018' AND '30.01.2018' AND discount NOT BETWEEN 500 AND 1000); ```

These queries should help you retrieve the specific data you need from the database. If you have any further questions or need additional assistance, feel free to ask!