List the premium customers who is not using the service within the last one week.if you have these tables: 1-'Premuim_USER'columns: Customer_ID, post_paid.2-'calls'columns: called_number, Customer_ID, call_date, call_time_started, Call_time_ended, transaction_no.

1. How many non cluster index we have use in one table?2. How we set the priority in the cluster index?3. What is co-releated sub query?

What is explain plan and what is tkproff?

these are the columns in the exam_report tableEXAM_CODE,STUDENT_ID,USER_ID,FIRST_NAME,STUDY_CENTER,COURSE,PAPER,APPEARENCEnow i want to know how many student have passed at the end of the yr for each paper? and if they r failed i need to know there mark of the last appearance for each paper(ie)he might have appeared 5 times but still he may have failed and i want the mark of the 5 appearance

Describe variable length record representation in files using byte string representation

What is BC and AD in date function of SQL?

How to use different types of locks in SQL query?

Why or why not?

Increment the salaries by 5% and add a comm. of 300 to the existing comm, and changing the clerk to jobs of all salesman whose salary is more than or equal to 1500.