展示を参照して、PRODUCT_INFORMATION テーブルの詳細を調べてください。

CATEGORY_ID 列の値が 12 または 13 で、SUPPLIER_ID 列の値が 102088 であるテーブルから PRODUCT_NAME を表示するという要件があります。次の SQL ステートメントを実行しました。
製品名を選択してください
FROM 製品情報
WHERE (カテゴリ ID = 12 AND カテゴリ ID = 13) AND サプライヤー ID = 102088; クエリの実行に関して正しいのはどれですか?

View and Exhibit and examine the structure and data in the INVOICE table.

Which two statements are true regarding data type conversion in query expressions? (Choose two.)

Which two statements are true regarding multiple-row subqueries? (Choose two.)

You want to display 5 percent of the rows from the SALEStable for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLDeven if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?
SELECT prod_id, cust_id, amount_sold

Examine the structure of the CUSTOMERS table: (Choose two.)

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?