Answered: n in detail so i can fully understand .…

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

Question

100%

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 - Display the first name and the first 3 characters of the employee's first name from the employee table.

Part B - Display the first name of employees which contain occurrences of 'a' and 'i' in the same name.

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 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