Answered: Please view attachment before…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Please view attachment before answering. The attachment is the table and its contents. I am in need of assistance with both parts, A and B. I am unsure on how i can go about attempting the question. I am using mysql terminal. Please explain solution in detail so i can fully understand . Attaching a visual will be of great help as well. (as in a screenshot or so) Thank you so much in advance!

Part A - Format the salary of the EMPLOYEE table to 15 characters long, right-padded with '*'. Label the column as 'Updated Salary'.

Part B - Select the employee's first name and the numeric position of the named character 'a' in the first name from the employee table

mysql> select * from employee;
--+--
| empno |first_name | last_name | hire_date
1 | John
| Mathew
2 | Riya
| Roy
3 | Leah
| PV
salary
| 2009-05-20 | 30000 |
| 2010-05-23 | 30000
2020-02-12 | 90000
3 rows in set (0.00 sec)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions