Write a Splunk query that would return the average of given field in a request included in an index over a period of time with a span of 15 seconds.

Task Write a query to retrieve the records of students who have their total marks greater than or equal to 500 Total marks refer to the sum of the marks of a single student. The result should be in the following format • STUDENT ID • SUM OF MARKS The result should be sorted in descending order by STUDENT D Table description Table: marks Name STUDENT_ID Type Description INTEGER This is the student's unique ID These are the marks obtained STUDENT MARKS INTEGER

sc 2. The First Orders A company maintains information about its orders in the ORDERS table. Write a query to print details of the earliest five orders (sorted by ORDER_DATE, ascending) that have not been delivered (i.e., STATUS is not DELIVERED). If there are more than five orders to choose from, select the ones with the lowest order ID. Sort the output in the increasing order of order ID. The output should contain ID, ORDER_DATE, STATUS, CUSTOMER_ID. Schema Table: Orders column type int column name id order_date status customer_id Sample Data Tables X fl f2 f3 KE date varchar(50) int f4 f5 f6 团 f7 ASUS VivoBook f80/