Which of the following can be part of an analytic view? (3 answers)

For which purpose can you use literal values in an Open SQL statement?

You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD). Which SELECT statement would you use in the definition? Please choose the correct answer.

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer.

The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.