Question
Find all customers who have at least two accounts at the perryridge branch
Answers
select customer_name from account natural join depositor
where branch_name = ‘Perryridge’ group by customer_name
having count(account_number)>=2;
Complex queries   Your Comment




  • Contributors: *,


Search
Can you Answer!!
  • Q Syntax for useradd commad
  • Q What is the difference between lookup (), lookup_ext () and lookup_seq ()?
  • Q Differentiate between the expression “++a” and “a++”?
  • Q An agency head may extend an employee’s probationary period by adding a period equal to _________. (A)The time the employee was absent from work or when the employee’s performance was below standard (B)The time reasonable for corrective or instructive action (C)The remainder of the employees probationary period or 12 months, whichever is greater (D)The time deemed reasonable by the Council based upon the totality of the circumstances.
  • Q Mount Elbrus (5,642 metres) is the highest mountain in which continent?
  • Q What is a Values Collection View
  • Q How ships are flooding?
  • Q Have you been involved in test estimation and how do you do it?
  • Q Please tell me about a time you had to coach an employee to perform a task?
  • Q What is the name of logic circuit which can add 2 binary digits?
  • Q Describe a project where conventional approach did not work. What did you do?