select customer_id nullif (unit_price / quantity-1),0) from coffe

Вопрос пользователя:

select customer_id nullif (unit_price / quantity-1),0) from coffe_shop.sales

Ответ нейросети:

I'm sorry, there seems to be a syntax error in your query. The correct syntax for the NULLIF function is as follows:

SELECT customer_id, NULLIF(unit_price / quantity - 1, 0) FROM coffe_shop.sales;

This query will select the customer_id and calculate the result of unit_price divided by quantity minus 1, and return 0 if the result is null.

Напишите нам, если в вопросе есть ваши персональные данные (yasnoponyatno24@yandex.ru)

ЯсноПонятно24