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

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

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

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

I'm sorry, but the query you provided is not valid. The COALESCE function in SQL requires at least two arguments. The correct syntax should be:

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

This query will select the customer_id and calculate the unit price divided by quantity minus 1. If the result is NULL, it will return 0 instead.

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

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