SQL Decoding Problem | Decoding the message problem

Published: 01 January 1970
on channel: Rahul Upadhya

355

In this SQL problem solving session, we work on to decode and identify the message sent by the sender using the decoding mapping.

Table creation & insertion script:
CREATE TABLE decode_details(
input_code CHAR(1),
output_code CHAR(1)
);

INSERT INTO decode_details VALUES('6','f'),('0','g'),('1',' '),('2','c'),('3','!'),('4','s'),('5','y'),('8','a'),('A','k'),('B','w'),('C','j'),('D','n'),('E','l'),('F','o'),('G','p'),('H','r'),('J','q'),('K','i'),('L','v'),('M','t'),('N',';'),('P','b'),('Q','x'),('R','h'),('S','u'),('T','-'),('U','.'),('V','d'),('W','e'),('X','m'),('Y','z'),('Z',',');

CREATE TABLE msg_info(
sender VARCHAR(100),
receiver VARCHAR(100),
message VARCHAR(1000)
);

INSERT INTO msg_info VALUES('Vedita','Varad','0FFV1ES2A16FH15FSH1E84M1WQ8X'),
('Vivek','Satwashila','R8GG51PWE8MWV1PKHMRV8531K18EB85416FH0WM1KM'),
('Vanita','Priyanka','K1B8DM1MF1LK4KM1AWV8HD8MR1MRK415W8HU'),
('Utkarsh','Nikhil','PEW44WV1BKMR181AKV1:)'),
('Prathamesh','Vishal','2R8DVH858DT1T14RRRR1VF1DFM1HWLW8E1T1MFG14W2HWM');

#sql #sqlprogramming #sqlqueries #interview #sqlfunctions

On this page of the site you can watch the video online SQL Decoding Problem | Decoding the message problem with a duration of hours minute second in good quality, which was uploaded by the user Rahul Upadhya 01 January 1970, share the link with friends and acquaintances, this video has already been watched 355 times on youtube and it was liked by 28 viewers. Enjoy your viewing!

643