alter table creditcards add COLUMN MinimumSalary VARCHAR(200) ; alter table creditcards add COLUMN AnnualFee varchar(200); SELECT * FROM `banksfinders`.`banks`; update `banksfinders`.`banks` set bankname='Deem Finance' where bankname LIKE '%Deem%'; update `banksfinders`.`banks` set bankname='Mashreq Bank' where bankname LIKE '%Mashreq%'; update `banksfinders`.`banks` set bankname='Emirates NBD Bank' where bankname LIKE '%Emirates NBD%'; update `banksfinders`.`banks` set bankname='RAK BANK' where bankname LIKE '%RAK%'; update `banksfinders`.`banks` set bankname='Emirates Islamic Bank' where bankname LIKE '%Emirates Islamic%'; update `banksfinders`.`banks` set bankname='NBQ' where bankname LIKE '%National Bank of Umm Al-Qaiwain%'; COMMIT use banksfinders; delete from `Fetures_transformed`; select * from `Fetures_transformed`; CREATE TABLE IF NOT EXISTS `Fetures_transformed` ( `CARD_name` VARCHAR(50) , `Minimum_Salary` VARCHAR(3) , `Annual_Fee` VARCHAR(28) , `Shrt_Features` VARCHAR(500) ); update `Fetures_transformed` set shrt_features=ltrim(rtrim(shrt_features)); update `Fetures_transformed` set shrt_features=REGEXP_REPLACE(shrt_features, '\\s+', ''); /*REGEXP_REPLACE(your_column, '\\s+', '');*/ INSERT INTO `Fetures_transformed` VALUES ('FAB Etihad Guest Infinite Credit Card','30K','2500','Get up t 110,000 welcme miles with a new card'), ('FAB Etihad Guest Infinite Credit Card','30K','2500','Earn up t 7.5 Etihad Guest Miles fr every AED 10 yu spend'), ('FAB Etihad Guest Infinite Credit Card','30K','2500','Free wrldwide airprt lunge access'), ('FAB Etihad Guest Signature Credit Card','15K','1500','Get up t 70,000 welcme miles with a new card'), ('FAB Etihad Guest Signature Credit Card','15K','1500','Earn up t 5.5 Etihad Guest Miles fr every AED 10 yu spend'), ('FAB Etihad Guest Signature Credit Card','15K','1500','Free airprt lunge access'), ('FAB Etihad Guest Platinum Credit Card','8k','500','Get up t 20,000 welcme miles with a new card'), ('FAB Etihad Guest Platinum Credit Card','8k','500','Earn up t 4 Etihad Guest Miles fr every AED 10 yu spend'), ('FAB Etihad Guest Platinum Credit Card','8k','500','Discunts n airprt transfers'), ('FAB Travel Card world Elite','25K','1500','A free return flight every year t ver 15 destinatins'), ('FAB Travel Card world Elite','25K','1500','12% cashback n all flight and htel bkings'), ('FAB Travel Card world Elite','25K','1500','0% freign currency cnversin fees with n hidden charges'), ('FAB Travel Card world Elite','25K','1500','Free lunge access fr yu and tw guests'), ('FAB Cashback Credit Card','5k','300','Save up t AED 1,000 each mnth!'), ('FAB Cashback Credit Card','5k','300','Get up t 5% cashback n fashin, dining ut and grcery shpping'), ('FAB Cashback Credit Card','5k','300','Get up t 3% cashback n internatinal spending'), ('FAB Cashback Credit Card','5k','300','Get up t 40% ff MakeMyTrip bkings,'), ('FAB Cashback Credit Card','5k','300','free wrldwide airprt lunge access and mre'), ('FAB du Titanium Credit Card','5K','No Annual fee','10% cashback n yur du pstpaid line bills'), ('FAB du Titanium Credit Card','5K','No Annual fee','10% cashback n du hme services bills'), ('FAB du Titanium Credit Card','5K','No Annual fee','10% cashback n prepaid line recharges'), ('FAB du Titanium Credit Card','5K','No Annual fee','10% cashback n yur du smartphne Privilege Plan mnthly data charges'), ('FAB GEMS World Credit Card','8K','AED 399','Save big n schl and family expenses.'), ('FAB GEMS World Credit Card','8K','AED 399','Save up t 4.25% n schl fees'), ('FAB GEMS World Credit Card','8K','AED 399','Get 10% cashback n schl bus, canteen, and unifrm purchases, plus nn-schl activities'), ('FAB GEMS World Credit Card','8K','AED 399','Receive a 20% discunt at Emaar attractins and mre'), ('FAB GEMS World Credit Card','8K','AED 399','2% cashback n spending'), ('BLUE FAB Infinite Credit Card by Al-Futtaim','40K','No Annual Fees','9% cashback n Al-Futtaim retail brands'), ('BLUE FAB Infinite Credit Card by Al-Futtaim','40K','No Annual Fees','4% cashback at Al-Futtaim schl, car and real estate brands'), ('BLUE FAB Infinite Credit Card by Al-Futtaim','40K','No Annual Fees','0% interest buy nw pay later plans n yur Al-Futtaim shpping'), ('BLUE FAB Signature Credit Card by Al-Futtaim','15K','Free For Life','7% cashback n Al-Futtaim retail brands'), ('BLUE FAB Signature Credit Card by Al-Futtaim','15K','Free For Life','3% cashback at Al-Futtaim schl, car and real estate brands'), ('BLUE FAB Signature Credit Card by Al-Futtaim','15K','Free For Life','Free airprt lunge access'), ('BLUE FAB Platinum Credit Card by Al-Futtaim','8K','Free For Life','6% cashback n Al-Futtaim retail brands'), ('BLUE FAB Platinum Credit Card by Al-Futtaim','8K','Free For Life','2% cashback at Al-Futtaim schl, car and real estate brands'), ('BLUE FAB Platinum Credit Card by Al-Futtaim','8K','Free For Life','0% interest buy nw pay later plans n yur Al-Futtaim shpping'), ('FAB SHARE Signature Credit Card','30K','1500','8% cashback n yur mall experiences'), ('FAB SHARE Signature Credit Card','30K','1500','6% cashback when yu shp at the mall'), ('FAB SHARE Signature Credit Card','30K','1500','15,000 bnus SHARE pints'), ('FAB SHARE Signature Credit Card','30K','1500','Get 2 fr 1 VX cinema tickets'), ('FAB SHARE Platinum Credit Card','10K','1000','6% cashback n mall experiences'), ('FAB SHARE Platinum Credit Card','10K','1000','4% cashback n mall spending'), ('FAB SHARE Platinum Credit Card','10K','1000','10,000 bnus SHARE pints'), ('FAB SHARE Platinum Credit Card','10K','1000','Get 2 fr 1 VX cinema tickets'), ('FAB SHARE Standard Credit Card','5K','No Annual Fees','7% cashback at Carrefur'), ('FAB SHARE Standard Credit Card','5K','No Annual Fees','5% cashback n mall experiences'), ('FAB SHARE Standard Credit Card','5K','No Annual Fees','3% cashback n mall spending'), ('FAB SHARE Standard Credit Card','5K','No Annual Fees','Get 2 fr 1 VX cinema tickets'), ('FAB Elite Credit Card','50K','Free for First year- 1200','First year free with a new card'), ('FAB Elite Credit Card','50K','Free for First year- 1200','Exclusive access t luxury beach clubs, gyms, premium dining experiences and mre'), ('FAB Elite Credit Card','50K','Free for First year- 1200','Mre cnvenience with 24/7 glbal cncierge and free valet parking'), ('FAB Elite Credit Card','50K','Free for First year- 1200','Guaranteed gift f gld bars and tree planting with each card'), ('FAB Elite Credit Card','50K','Free for First year- 1200','Earn up t 500,000 FAB Rewards n all yur spending'), ('CBD One Credit Card','5K','Free for Life','Free fr life'), ('CBD One Credit Card','5K','Free for Life','Earn up t AED 135 cashback every mnth'), ('CBD One Credit Card','5K','Free for Life','50% ff n cinema tickets'), ('CBD One Credit Card','5K','Free for Life','Cmplimentary valet parking'), ('CBD Yes Rewards Credit Card','5K','Free For First year','First year free'), ('CBD Yes Rewards Credit Card','5K','Free For First year','Welcme bnus f 20,000 Yes Rewards wrth AED 200'), ('CBD Yes Rewards Credit Card','5K','Free For First year','Save up t 15% n fuel & mre'), ('CBD Yes Rewards Credit Card','5K','Free For First year','Cmplimentary valet parking, cinema discunts and mre'), ('CBD Visa Smiles Signature Credit Card','5k','F Y F then AED 199','A chance t win 1,000,000 Smiles Pints'), ('CBD Visa Smiles Signature Credit Card','5k','F Y F then AED 199','Cmplimentary glbal Airprt Visa Cmpanin'), ('CBD Visa Smiles Signature Credit Card','5k','F Y F then AED 199','10 Smiles pints n all Etisalat channels, Smiles app and elGrcer spends'), ('CBD Visa Smiles Signature Credit Card','5k','F Y F then AED 199','90-day cmplimentary subscriptin t Smiles Unlimited'), ('RAK Bank World Credit Card','20K','FYF then 950','Free fr First year'), ('RAK Bank World Credit Card','20K','FYF then 950','Get AED 1,000 welcme bnus '), ('RAK Bank World Credit Card','20K','FYF then 950','Up t 10% cashback n supermarket'), ('RAK Bank World Credit Card','20K','FYF then 950','50% discunt n VX Cinemas'), ('RAK Bank World Credit Card','20K','FYF then 950','10% cashback n travel, flight and htel bkings'), ('RAK Bank Titanium Credit Card','8k','Free for Life','Cashback f up t 5% n supermarket & dining spends and up t 50% fr entertainment spends'), ('RAK Bank Titanium Credit Card','8k','Free for Life','Get AED 500 welcme bnus'), ('RAK Bank Titanium Credit Card','8k','Free for Life',' Get up t AED 600 cashback per mnth'), ('RAK Bank Titanium Credit Card','8k','Free for Life',' Free fr life'), ('RAK Bank Air Arabia Platinum Credit Card','5K','AED 420*','Earn 1.75 Air rewards per AED 5 fr spends'), ('RAK Bank Air Arabia Platinum Credit Card','5K','AED 420*','Get a jining bnus f 20,000 AirRewards'), ('RAK Bank Air Arabia Platinum Credit Card','5K','AED 420*','Enjy benefits with n maximum caps'), ('RAK Bank RED Credit Card','5k','Free for Life','Enjy a free-fr-life card and great rewards'), ('RAK Bank RED Credit Card','5k','Free for Life','Cashback f up t 1.5% n lcal & internatinal spends'), ('RAK Bank RED Credit Card','5k','Free for Life','Get up t AED 300 cashback'), ('RAK Bank Elevate credit card ','35K','Spend base',NULL), ('RAK Bank Elevate credit card ','35K','Spend base',NULL), ('RAK Bank Elevate credit card ','35K','Spend base','Tier-based Mnthly Fee'), ('RAK Bank Elevate credit card ','35K','Spend base',NULL), ('RAK Bank Elevate credit card ','35K','Spend base','Up t 4% cashback n all yur spends'), ('RAK Bank Elevate credit card ','35K','Spend base',NULL), ('RAK Bank Elevate credit card ','35K','Spend base','Up t 3% value back n airline and htel reward redemptin'), ('RAK Bank Elevate credit card ','35K','Spend base',NULL), ('RAK Bank Elevate credit card ','35K','Spend base','N Freign Currency Fee'), ('Emirates Islamic Emarati Credit Card','12K','No Annual fee','Welcme Bnus: Get AED 1,000 in the frm f EI SmartMiles. *'), ('Emirates Islamic Emarati Credit Card','12K','No Annual fee','Exclusive fr UAE natinals.'), ('Emirates Islamic Emarati Credit Card','12K','No Annual fee','N Annual Membership Fee.'), ('Emirates Islamic Emarati Credit Card','12K','No Annual fee','Cmplimentary airprt lunge access.'), ('Emirates Islamic Flex Elite Credit Card','15K','735','175,000 EI SmartMiles Welcme Bnus'), ('Emirates Islamic Flex Elite Credit Card','15K','735','3.75% cashback n internatinal spend'), ('Emirates Islamic Flex Elite Credit Card','15K','735','Unlimited airprt lunge access fr yu + guest.'), ('Emirates Islamic Flex Elite Credit Card','15K','735','Unlimited runds f glf.'), ('Emirates Islamic RTA Credit Card','5K','No Annual Fee','N Annual Fee'), ('Emirates Islamic RTA Credit Card','5K','No Annual Fee','10% Cashback n RTA Transprt'), ('Emirates Islamic RTA Credit Card','5K','No Annual Fee','10% Cashback n Fuel'), ('Emirates Islamic RTA Credit Card','5K','No Annual Fee','2.25% Cashback n ther Spends'), ('Emirates Islamic Cashback Credit Card','5k','No AMF for first year*','5% cash back n telecm expenses.'), ('Emirates Islamic Cashback Credit Card','5k','No AMF for first year*','5% cash back n electrnic stre purchases.'), ('Emirates Islamic Cashback Credit Card','5k','No AMF for first year*','N AMF fr first year* subject t retail spend f AED 3,000 within 90 days.'), ('Emirates Islamic Cashback Credit Card','5k','No AMF for first year*','Up t 1% guaranteed cash back n all lcal and internatinal transactins.'), ('Emirates Islamic Cashback Plus Credit Card','12K','No AMF for first year*','Up t 10% cash back n grceries, educatin, dining and telecm.'), ('Emirates Islamic Cashback Plus Credit Card','12K','No AMF for first year*','N Annual Membership Fee fr first year* subject t retail spend f AED 5,000 within 90 days.'), ('Emirates Islamic Cashback Plus Credit Card','12K','No AMF for first year*','Unlimited cmplimentary access t ver 1,000 airprt lunges wrldwide.'), ('Emirates Islamic Cashback Plus Credit Card','12K','No AMF for first year*','Cmplimentary Access t Dubai Ladies Club & Sharjah Ladies Club.'), ('Emirates Islamic Switch Cashback Credit Card','5K','Free for First Year','Welcme Bnus f AED 500 Cashback pints n spends f AED 15,000 within 60 days f Card apprval.'), ('Emirates Islamic Switch Cashback Credit Card','5K','Free for First Year','Lifestyle - 4% cashback n Supermarkets, Dining & Educatin with 8% cashback n Fuel.'), ('Emirates Islamic Switch Cashback Credit Card','5K','Free for First Year','Travel - 4% cashback n Airlines, Htels & Dining.'), ('Emirates Islamic Switch Cashback Credit Card','5K','Free for First Year','2 "Buy 1 Get 1" cmplimentary mvie tickets every mnth.'), ('Emirates Islamic Etihad Guest Premium Credit Card','20K','No AMF for first year*','N AMF fr first year*'), ('Emirates Islamic Etihad Guest Premium Credit Card','20K','No AMF for first year*','Fast-Track Etihad Guest Gld Tier Status'), ('Emirates Islamic Etihad Guest Premium Credit Card','20K','No AMF for first year*','Up t 3.5 Etihad Guest Miles per USD spent'), ('Emirates Islamic Etihad Guest Premium Credit Card','20K','No AMF for first year*','Cmplimentary airprt transfers, airprt lunge access, glf & valet parking.'), ('Emirates Islamic Etihad Guest Premium Credit Card','20K','No AMF for first year*','Cmplimentary Access t Dubai Ladies Club.'), ('Emirates Islamic Etihad Guest Saqer Credit Card','12k','No AMF for first year*','N AMF fr first year*'), ('Emirates Islamic Etihad Guest Saqer Credit Card','12k','No AMF for first year*','Fast-Track Etihad Guest Silver Tier Status.'), ('Emirates Islamic Etihad Guest Saqer Credit Card','12k','No AMF for first year*','Up t 3 Etihad Guest Miles per USD spent.'), ('Emirates Islamic Etihad Guest Saqer Credit Card','12k','No AMF for first year*','Cmplimentary Access t Dubai Ladies Club.'), ('Emirates Islamic Etihad Guest Saqer Credit Card','12k','No AMF for first year*','Cmplimentary airprt transfers, airprt lunge access, glf & valet parking.'), ('Emirates Islamic Etihad Guest Ameera Credit Card',NULL,'No AMF for first year*','N AMF fr first year*'), ('Emirates Islamic Etihad Guest Ameera Credit Card',NULL,'No AMF for first year*','Fast-Track Etihad Guest Silver Tier Status.'), ('Emirates Islamic Etihad Guest Ameera Credit Card',NULL,'No AMF for first year*','Up t 3 Etihad Guest Miles per USD spent.'), ('Emirates Islamic Etihad Guest Ameera Credit Card',NULL,'No AMF for first year*','Cmplimentary Access t Dubai Ladies Club.'), ('Emirates Islamic Etihad Guest Ameera Credit Card',NULL,'No AMF for first year*','Cmplimentary airprt transfers, airprt lunge access, glf & valet parking.'), ('Emirates Islamic Etihad Guest Platinum Credit Card','5k','No AMF for first year* ','N AMF fr first year*'), ('Emirates Islamic Etihad Guest Platinum Credit Card','5k','No AMF for first year* ','Up t 2 Etihad Guest Miles per USD spent.'), ('Emirates Islamic Etihad Guest Platinum Credit Card','5k','No AMF for first year* ','Unlck 10% Etihad Guest Miles Discunt Vucher'), ('Emirates Islamic Etihad Guest Platinum Credit Card','5k','No AMF for first year* ','Discunts n dining, travel, htels and shpping.'), ('Emirates Islamic Skywards Black Credit Card','35K','AED 2k or AED 3.5K','Up t 3.5 Skywards Miles per USD spent.'), ('Emirates Islamic Skywards Black Credit Card','35K','AED 2k or AED 3.5K','Autmatic upgrade t Emirates Skywards Silver membership.'), ('Emirates Islamic Skywards Black Credit Card','35K','AED 2k or AED 3.5K','Fast Track t Emirates Skywards Gld Tier Membership'), ('Emirates Islamic Skywards Black Credit Card','35K','AED 2k or AED 3.5K','Unlimited Cmplimentary glf any day f the week.'), ('Emirates Islamic Skywards Black Credit Card','35K','AED 2k or AED 3.5K','Unlimited cmplimentary access t ver 1000+ airprt lunges with a guest.'), ('Emirates Islamic Skywards Infinite Credit Card','20K','AED 2K','AMF waiver fr First Year subject t retail spends f AED 30K within 90 days frm apprval'), ('Emirates Islamic Skywards Infinite Credit Card','20K','AED 2K','Up t 2 Skywards Miles per USD spent'), ('Emirates Islamic Skywards Infinite Credit Card','20K','AED 2K','Autmatic upgrade t Emirates Skywards Silver membership'), ('Emirates Islamic Skywards Infinite Credit Card','20K','AED 2K','Unlimited Cmplimentary glf any day f the week'), ('Emirates Islamic Skywards Infinite Credit Card','20K','AED 2K','Unlimited cmplimentary access t ver 1000+ airprt lunges with a guest'), ('Emirates Islamic Skywards Signature Credit Card','12k','AED 700','Up t 1.5 Skywards Miles per USD spent.'), ('Emirates Islamic Skywards Signature Credit Card','12k','AED 700','Tw runds f Cmplimentary glf any day f the week.'), ('Emirates Islamic Skywards Signature Credit Card','12k','AED 700','1 cmplimentary valet parking service per mnth.'), ('Emirates Islamic Skywards Signature Credit Card','12k','AED 700','Unlimited cmplimentary access t ver 1000+ airprt lunges.'), ('Emirates Islamic Skywards Signature Credit Card','12k','AED 700','Cmplimentary Access t Dubai Ladies Club.'), ('HSBC Cash+ Credit Card','30K','Free for 1st Year-then 1000','Welcme Bnus AED 500'), ('HSBC Cash+ Credit Card','30K','Free for 1st Year-then 1000','Free fr First Year'), ('HSBC Cash+ Credit Card','30K','Free for 1st Year-then 1000','Travel Insurance'), ('HSBC Cash+ Credit Card','30K','Free for 1st Year-then 1000','Cashback'), ('HSBC Cash+ Credit Card','30K','Free for 1st Year-then 1000','Careem Plus & Zmat Gld subscriptin'), ('HSBC Live+ Credit Card','5K','Free for 1st Year*','Welcme Bnus AED 500'), ('HSBC Live+ Credit Card','5K','Free for 1st Year*','Free fr First Year'), ('HSBC Live+ Credit Card','5K','Free for 1st Year*','5% cashback n fuel'), ('HSBC Live+ Credit Card','5K','Free for 1st Year*','Earn 6% cashback n dining'), ('HSBC Live+ Credit Card','5K','Free for 1st Year*','Travel Insurance'), ('HSBC Live+ Credit Card','5K','Free for 1st Year*','Zmat Gld subscriptin'), ('HSBC Max Rewards Credit Card','10K','Free for 1st Year','Welcme Bnus AED 500'), ('HSBC Max Rewards Credit Card','10K','Free for 1st Year','Free fr 1st year'), ('HSBC Max Rewards Credit Card','10K','Free for 1st Year','Travel Insurance'), ('HSBC Max Rewards Credit Card','10K','Free for 1st Year','1 Air Mile fr every AED 1'), ('HSBC Max Rewards Credit Card','10K','Free for 1st Year','Dining Discunts'), ('HSBC Emirates Skywards Infinite Credit Card','30K','AED 2,500','Welcme Bnus up t 50K Skywards Miles'), ('HSBC Emirates Skywards Infinite Credit Card','30K','AED 2,500','Airprt Lunge Access'), ('HSBC Emirates Skywards Infinite Credit Card','30K','AED 2,500','Silver Tier Benefits'), ('HSBC Emirates Skywards Infinite Credit Card','30K','AED 2,500','Multi-trip travel insurance'), ('HSBC Emirates Skywards Infinite Credit Card','30K','AED 2,500','Get a cmplimentary Zmat Gld Dining membership'), ('HSBC Emirates Skywards Infinite Credit Card','30K','AED 2,500','Get a cmplimentary Careem Plus subscriptin'), ('HSBC Emirates Skywards Signature Credit Card','10K','AED 1,000','Welcme Bnus up t 20K Skywards Miles'), ('HSBC Emirates Skywards Signature Credit Card','10K','AED 1,000','Airprt Lunge Access'), ('HSBC Emirates Skywards Signature Credit Card','10K','AED 1,000','Silver Tier Benefits'), ('HSBC Emirates Skywards Signature Credit Card','10K','AED 1,000','Multi-trip travel insurance'), ('HSBC Emirates Skywards Signature Credit Card','10K','AED 1,000','Get a cmplimentary Zmat Gld Dining membership'), ('HSBC Emirates Skywards Signature Credit Card','10K','AED 1,000','Get a cmplimentary Careem Plus subscriptin'), ('Liv Bank Cashback Credit Card','5K','Free for life','Free fr Life'), ('Liv Bank Cashback Credit Card','5K','Free for life','Cashback'), ('Liv Bank Cashback Credit Card','5K','Free for life','Airprt Lunge Access'), ('Liv Bank Cashback Credit Card','5K','Free for life','Mvie Discunts'), ('Liv Bank Cashback Credit Card','5K','Free for life','Skywards Miles'), ('Liv Bank Cashback Plus Credit Card','10k','AED 700','Cashback'), ('Liv Bank Cashback Plus Credit Card','10k','AED 700','Airprt Lunge Access'), ('Liv Bank Cashback Plus Credit Card','10k','AED 700','Mvie Discunts'), ('Liv Bank Cashback Plus Credit Card','10k','AED 700','Airprt Transfer'), ('Liv Bank Cashback Plus Credit Card','10k','AED 700','Travel Insurance'), ('NBQ Infinite Credit Card','30k','AED 1000','Airprt Lunge Access'), ('NBQ Infinite Credit Card','30k','AED 1000','Free supplementary card'), ('NBQ Infinite Credit Card','30k','AED 1000','Balance Transfer'), ('NBQ Infinite Credit Card','30k','AED 1000','Easy Payment Plan'), ('NBQ Platinum Credit Card','15k','AED 500','Airprt Lunge Access'), ('NBQ Platinum Credit Card','15k','AED 500','Travel Insurance'), ('NBQ Platinum Credit Card','15k','AED 500','Balance Transfer'), ('NBQ Platinum Credit Card','15k','AED 500','Easy Payment Plan'), ('NBQ Gold Credit Card','8k','Free for life','Free fr Life'), ('NBQ Gold Credit Card','8k','Free for life','Travel Insurance'), ('NBQ Gold Credit Card','8k','Free for life','Balance Transfer'), ('NBQ Gold Credit Card','8k','Free for life','Easy Payment Plan'), ('DIB SHAMS Infinite Covered Card','50K','Free for 1st year','Travel Insurance'), ('DIB SHAMS Infinite Covered Card','50K','Free for 1st year','Airprt lunge access'), ('DIB SHAMS Infinite Covered Card','50K','Free for 1st year','Buy 1 Get 1’ ffer n Csta Cffee'), ('DIB SHAMS Infinite Covered Card','50K','Free for 1st year','4 Airprt transfers'), ('DIB SHAMS Signature Covered Card',NULL,'Free for 1st year','Travel Insurance'), ('DIB SHAMS Signature Covered Card',NULL,'Free for 1st year','Airprt lunge access'), ('DIB SHAMS Signature Covered Card',NULL,'Free for 1st year','Free Radside assistance'), ('DIB SHAMS Signature Covered Card',NULL,'Free for 1st year','2 Airprt transfers');