Write a query to create a view that shows the average and total orders for each salesman after his or her name. (Assume all names are unique)
SIKSHAPATH Latest Questions
Consider a two-dimensional array arr[20][20] which has base address = 1000 and the number of bytes per element of the array = 4. Now, compute the address of the element arr[9][6] assuming that the elements are stored in column-major order.
Write a PL/SQL program to convert a temperature in scale Fahrenheit to Celsius and vice versa.
Write a program to sort an array of floating-point numbers in descending order using merge sort ?
Consider the following relations: Salesman salesman_id | name | city | commission ————-+————+———-+———— 5001 | James Hoog | New York | 0.15 5002 | Nail Knite | Paris | 0.13 5005 | Pit Alex | London | 0.11 5006 | Mc Lyon | Paris | 0.14 5007 | ...
