Advertisement
Guest User

Untitled

a guest
Sep 25th, 2017
384
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. select store, category, brand, model, normalPrice, offerPrice, minimumPrice, round(normalPrice/4) from product where ROUND(normalPrice/4) > offerPrice and offerPrice > 0;
  2. +--------+------------+-------+-------------------------+-------------+------------+--------------+----------------------+
  3. | store | category | brand | model | normalPrice | offerPrice | minimumPrice | round(normalPrice/4) |
  4. +--------+------------+-------+-------------------------+-------------+------------+--------------+----------------------+
  5. | Abcdin | smartphone | Azumi | A40C Style Blanco Claro | 59990 | 14990 | 14990 | 14998 |
  6. +--------+------------+-------+-------------------------+-------------+------------+--------------+----------------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement