Convert and compare: CAST, NULLIF, ILIKE and paging · exercise 1 of 1 · free preview
CAST(value AS type) converts a value to another type. PostgreSQL also accepts the short form value::type. Casting a decimal to integer rounds, it does not cut off the decimals.
Show each product's name and its unit price as a whole number (type integer), named whole_price. Order by product_id.
Tables in this practice shop
customersproductsordersorder_items