Actually this is in mysql and i am not able to select mysql tag.
waq to display customerid,cusname,contactno,num of movies issued to each customer
and category. display the customer who has issued for more than
one movie from that caregory.display phone num as "+91-987-654-3210".
find the ER diagram in below link
https://drive.google.com/open?id=0Bxich9-8Q8B5dVhXS25nWEZtOUE&authuser=0
Customer_master
CUS001 AMIT 9876543210 ADD1 2012-02-12 21
CUS002 ABDHUL 8765432109 ADD2 2012-02-12 21
CUS003 GAYAN 7654321098 ADD3 2012-02-12 21
CUS004 RADHA 6543210987 ADD4 2012-02-12 21
CUS005 GURU ADD5 2012-02-12 21
CUS006 MOHAN 4321098765 ADD6 2012-02-12 21
CUS007 NAME7 3210987654 ADD7 2012-02-12 21
CUS008 NAME8 2109876543 ADD8 2013-02-12 21
CUS009 NAME9 ADD9 2013-02-12 21
CUS010 NAM10 9934567890 ADD10 2013-02-12 21
CUS011 NAM11 9875678910 ADD11 2013-02-12 21
Customer_issue_details
IS001 CUS001 MV001 2012-05-13 2012-05-13 2012-05-13
IS002 CUS001 MV001 2012-05-01 2012-05-16 2012-05-16
IS003 CUS002 MV004 2012-05-02 2012-05-06 2012-05-16
IS004 CUS002 MV004 2012-04-03 2012-04-16 2012-04-20
IS005 CUS002 MV009 2012-04-04 2012-04-16 2012-04-20
IS006 CUS003 MV002 2012-03-30 2012-04-15 2012-04-20
IS007 CUS003 MV003 2012-04-20 2012-05-05 2012-05-05
IS008 CUS003 MV005 2012-04-21 2012-05-07 2012-05-25
IS009 CUS003 MV001 2012-04-22 2012-05-07 2012-05-25
IS010 CUS003 MV009 2012-04-22 2012-05-07 2012-05-25
IS011 CUS003 MV010 2012-04-23 2012-05-07 2012-05-25
IS012 CUS003 MV010 2012-04-24 2012-05-07 2012-05-25
IS013 CUS003 MV008 2012-04-25 2012-05-07 2012-05-25
IS014 CUS004 MV007 2012-04-26 2012-05-07 2012-05-25
IS015 CUS004 MV006 2012-04-27 2012-05-07 2012-05-25
IS016 CUS004 MV006 2012-04-28 2012-05-07 2012-05-25
IS017 CUS004 MV001 2012-04-29 2012-05-07 2012-05-25
IS018 CUS010 MV008 2012-04-24 2012-05-07 2012-05-25
IS019 CUS011 MV009 2012-04-27 2012-05-07 2012-05-25
Movie_Master
MV001 DIEHARD 2012-05-13 ENGLISH 4 2HRS U/A ACTION DIR1 L1 L2 100
MV002 THE MATRIX 2012-05-13 ENGLISH 4 2HRS A ACTION DIR2 L1 L2 100
MV003 INCEPTION 2012-05-13 ENGLISH 4 2HRS U/A ACTION DIR3 L1 L2 100
MV004 DARK KNIGHT 2012-05-13 ENGLISH 4 2HRS A ACTION DIR4 L1 L2 100
MV005 OFFICE S 2012-05-13 ENGLISH 4 2HRS U/A COMEDY DIR5 L1 L2 100
MV006 SHAWN OF DEAD 2012-05-13 ENGLISH 4 2HRS U/A COMEDY DIR6 L1 L2 100
MV007 YOUNG FRANKEN 2012-05-13 ENGLISH 4 2HRS U/A COMEDY DIR7 L1 L2 100
MV008 CAS 2012-05-13 ENGLISH 4 2HRS A ROMANCE DIR8 L1 L2 100
MV009 GWW 2012-05-13 ENGLISH 4 2HRS A ROMANCE DIR9 L1 L2 100
MV010 TITANIC 2012-05-13 ENGLISH 4 2HRS A ROMANCE DIR10 L1 L2 100
MV011 THE NOTE BOOK 2012-05-13 ENGLISH 4 2HRS A ROMANCE DIR11 L1 L2 100
additional information copied from comment below
select m.customer_id,customer_name,
cast(concat('+91-',substring(contact_no,1,3),'-',substring(contact_no,4,3),'-',
substring(contact_no,7) ) as char)as contact_no,
count(i.movie_id) as no_of_movies,movie_category
from customer_master m
join customer_issue_details i
on m.customer_id = i.customer_id
join movies_master mv
on i.movie_id = mv.movie_id
group by m.customer_id
having count(m.customer_id) >1;