Question: please tell me what i am doing wrong 1- Write an SQL query to show the age of each employee. 2- Write an SQL query

please tell me what i am doing wrong

1- Write an SQL query to show the age of each employee. 2- Write an SQL query to show the CustomerName and the complete SELECT truncate((DATEDIFF(curdate(), 'BirthDate)/365), ) AS 'Age' FROM employees; Result Grid Fiber Rows: Export Wrap Call Content II Age

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1- Write an SQL query to show the age of each employee. 2- Write an SQL query to show the CustomerName and the complete address of each customer (the statement should return only two columns;...

Answer the following questions. Make sure you use comments in your SQL file to clarify/show which SQL statement is the answer to which question. The questions are: 1- Write an SQL query to show the...

1- Write an SQL query to show the birthdate and name of each employee. 2- Write an SQL query to show the CustomerName and the complete address of each custe (the statement should return only two...

Answer the following questions. Make sure you use comments in your SQL file to clarify / show which SQL statement is the answer to which question. The questions are: 1 . Write an SQL query to show...

homework. Answer the following questions. Make sure you use comments in your SQL file to clarify/show which SQL statement is the answer to which question. The questions are: 1- Write an SQL query to...

1- Show the first name and last name of customers. SELECT CustFirstName,CustLastName FROM customers; Don't forget to select the database SalesOrder before running the SELECT statement. You can select...

1- Write an SQL query to show the CustomerName and Country of Customers. 2- Write an SQL query to show all Countries (no duplicates), order them alphabetically. 3- Write an SQL query to show the...

1) Write a SQL query to show the country name where maximum number of movies has been produced, along with the number of movies produced. 2) Write a SQL query to show all the genre_id in one column...

Analysis of workforce data, performance, and engagement. Datasets: Employees Table Column Name Data Type Description employee_id Integer Unique identifier for each employee department_id Integer...

Let X equal the number of milliliters of a liquid in a bottle that has a label volume of 350 ml. Assume that the distribution of X is N(, 4). To test the null hypothesis H0: = 355 against the...

1. How many Hamiltonian paths exist for the following graph? Recall that for an undirected graph the reverse path is the same as the original path; for example, E,C,D,A,F,B is the same thing as...

10. Write instructions that divide 276 by 10 and store the result in a 16-bit variable val1.

Johnny's Hamburgers issued 5%, 10-year bonds payable at 85 on December 31, 2016. At December 31, 2018, Johnny reported the bonds payable as follows: Hamburgers issued %, 10-year bonds payable at on...

5. Conduct a phone or personal interview with a training manager. Ask this person to discuss how training has changed in the past five years and how he or she believes it will change in the future.

6. Vanguard

6. Training identified the Top 125 companies for training (see Training, February 2009). The top ten ranked companies were: