WRITE A QUERY TO SELECT A NAME FROM ONE TABLE WHICH HAS ID ,NAME AND SALARY FROM ANOTHER TABLE WHICH HAS ID ,SALARY AS SECOND MAXIMUM?

BASICALLY IT IS RELATED TO SQL. WE CAN DO IN THIS PROCESS, SELECT[NAME],[PHONE NO] FROM[CUSTOMERS] WHERE[COUNTRY]="FRANCE"; AS THE PROCESS SHOWN ABOVE ,SHOWN TO THE INTERVIEWER IN THE SIMILAR WAY,NO NEED OF GOING DEEP.