Please show me what this part would look like in sql The new

Please show me what this part would look like in sql:

The new system generated password should be formatted as follows: lowercase first 3 letters of customer last name, then the number produced by multiplying the customer birthday by their birth month, and then the uppercase first 3 letters of their first name. For example: John Smith has a birthday on 7/18, so his new password would be “smi126JOH”. Order by customer first name, alphabetically.

MOVIES A CTORS ACTORS MOVIES DIRECTORS MOVIES FORMAT MOVI EID NUMBER ACTO RID NUMBER (8 OV NUMBER MOVIEID NUMBER ACTORID NUMBER (6 AFNAME VARCHAR2 (25 DIRECTORID CHAR (8 FORMATID AL NAME VARCHAR2 35 MOVIES ACTORS K (MOVI EID ACTORID MOVIES DIRECTORS P MOVIEID, DIRECTORID MOVIES ORMAT FK (MOVI EID ORMAT TID BIRTH DATE DATE MOVIES ACTORS CON (MOVIEIDE MOVIES DIRECTORS FK (MOVIEID RMAT (FORMATID) GENDER MovIES MOVIES ACTORS CON (ACTO RID DIRECTORS FK2 (DIRECTORID EID ACTOR PK (ACTORID MOVIES ORMAT ORMATID CHAR FORMA DESCRIPT VARCHAR2 25 RMAT PK ORMATID MOVIES AWARDS PK (MOVIEID, AVARDID) PK MOVIES (MOVIEID) DIRECTORS K (DIRECTORID MOVIES AWARDS K (M OV MOVIES AWARDS K2 (AWARDID MOVIES GENRES MOVI EID NUMBER (.0 GENRE CODE RATINGS 100 CUSTOMERS MOVIES GENRES K (MOVI EID. GENRE CODE AWARDS MOVIEID NUMBER (.00 CUST CHAR (16) K GENRE S-MOVIES GENRES (GENRECODE) AVARDID RATING NUMBER CFNAME VARCHAR2 26 FK MovIE Mov E-GENRES (MOVIEID) AVIARD TITLE VARCHAR2 00 RDATE DATE CLNAME VARCHAR2 (50 CUST CHAR AWARDS K (ANIARDID VARCHAR2 (50 RATINOID NUMBER (10) C PASSWORD VARCHAR2 RATINGS 100-P RATIN GID) BIRTH MONTH NUMBER 2) GENRES BIRTH DAY NUMBER 2) USTID GENI VARCHAR2 3) REDITTYPI VARCHAR2 FK RATING Movies (MovIEID) STRIMPLANID CHAR (A) GENRENAME VARCHAR2 e5 NUMB VARCHAR2 DESCRIPTION VARCHAR2 00) CREDIT NAME VARCHAR2 75 GENRES GENRECODE PRICEPERMONTH NUMBER (5,2) CREDIT EXPIMTH NUMBER 02) ADDRESSES G PLAN-P K (STRM PLANID) REDITI NUMBER CUST ANKROUTING VARCHAR2 ADDRTYPE BANKACCOUNT VARCHAR2 (26 STREET ADDR VARCHAR2 (50) BANKHOLDER VARCHAR2 76 STREET ADDR2 VARCHAR2 (50) DRIVER VARCHAR2 25 CITY VARCHAR2 135) STATE CHAR DVD PLAN STATE CHAR (2) NUMBKIDS NUMBER 2) DVDPLANID CHAR (5 CHAR (5) PHONE NUMB CHAR DESCRIPTION VARCHAR2 00 STRMPLA NID CHAR (A) PK ADDRESSES (CUST DORTYP PRIC EPERMONTH NUMBER (5.2 DVD PLANID CHAR (5) FK ADDRESS USTOMER (CUST ID) DVD PLAN P DVDPLANID PK CUSTOMER (CUSTID) CUSTOMER S CON (STRM PLAN ID) CusTOMER S-CON2 (DVDFLA NID

Solution

SELECT LOWER(SUBSTR(CLNAME,1,3)) + CAST((CBIRTHDAY*CBIRTHMONTH) AS VARCHAR) + UPPER(SUBSTR(CFNAME,1,3)) FROM CUSTOMERS ORDER BY CFNAME;