Форум пользователей MySQL

Добрый вечер.
Сами задания прикрепил ,Запросы делаются под phpMyAdmin
Помогите найти ошибки и исправить. Мне указали на самую грубую ошибку это: rpm_future_retail.location = rpm_zone_future_retail.zone - пока незнаю чем заменить
Остальные нужно найти и исправить тоже.
Вот что у меня получилось:

==================================
Test task description new 1 level:
==================================
1) SELECT item, selling_retail, selling_retail_currency FROM rpm_zone_future_retail WHERE zone = 1 and action_date BETWEEN '01.06.2011' AND '20.07.2012';

2а) SELECT rpm_future_retail.item,rpm_future_retail.action_date, rpm_future_retail.selling_retail, rpm_future_retail.selling_retail_currency FROM rpm_future_retail, rpm_zone_future_retail WHERE rpm_future_retail.item = rpm_zone_future_retail.item, rpm_future_retail.location = rpm_zone_future_retail.zone AND rpm_zone_future_retail.selling_retail = ' ';

2b) SELECT rpm_future_retail.item,rpm_future_retail.action_date, rpm_future_retail.selling_retail, rpm_future_retail.selling_retail_currency FROM rpm_future_retail, rpm_zone_future_retail WHERE rpm_future_retail.item = rpm_zone_future_retail.item, rpm_future_retail.location = rpm_zone_future_retail.zone AND rpm_zone_future_retail.selling_retail <> rpm_future_retail.selling_retail;

==================================
Test task description new 2 level:
==================================
1)CREATE TABLE new_table
  AS (SELECT zone, item, selling_retail_1, selling_retail_2, selling_retail_difference
      FROM rpm_zone_future_retail WHERE zone = rpm_zone_future_retail.zone
Like = '1' AND item = rpm_zone_future_retail.item AND selling_retail_1 = rpm_zone_future_retail.selling_retail Like rpm_zone_future_retail.action_date = '01.06.2011'  AND selling_retail_2 = rpm_zone_future_retail.selling_retail Like rpm_zone_future_retail.action_date = '20.07.2012' AND selling_retail_difference = (selling_retail_2 - selling_retail_1);

2а) CREATE TABLE new_table
  AS (SELECT location, amount_of_items FROM rpm_zone_future_retail, rpm_future_retail WHERE location = rpm_future_retail.location Like rpm_zone_future_retail.zone = rpm_future_retail.location AND amount_of_items = SUM(rpm_zone_future_retail.item) Like rpm_zone_future_retail.selling_retail = ' ';

2b) CREATE TABLE new_table
  AS (SELECT zone,location,item, selling_zone, selling_location FROM rpm_zone_future_retail, rpm_future_retail WHERE zone = rpm_zone_future_retail.zone AND location = rpm_future_retail.location Like rpm_future_retail.location = rpm_zone_future_retail.zone AND item = rpm_zone_future_retail.item AND selling_zone = rpm_zone_future_retail.selling_retail AND selling_location = rpm_future_retail.selling_retail;

==================================
Test task description new 3 level:
==================================
1)CREATE TABLE ITEM_ZONE_PRICE 
      ( zone    integer,
        item    integer,
        date    date,
        price    float);
INSERT INTO ITEM_ZONE_PRICE (zone,item,date,price)
VALUES ('1','03020318', '', '') SELECT date, price  FROM rpm_zone_future_retail WHERE date = rpm_zone_future_retail.action_date BETWEEN '01.06.2011' AND '01.09.2012' price = selling_retail  Like rpm_zone_future_retail.zone = '1' AND rpm_zone_future_retail.item = '03020318' ;

2)
UPDATE RPM_FUTURE_RETAIL
SET RPM_FUTURE_RETAIL.selling_retail= RPM_ZONE_FUTURE_RETAIL.selling_retail
WHERE RPM_FUTURE_RETAIL.selling_retail <> RPM_ZONE_FUTURE_RETAIL.selling_retail

Отредактированно DimasDay (28.08.2014 19:56:08)

---

Прикрепленные файлы:
Test task description new 3 level.doc, Размер: 31,744 байт, Скачано: 1,401