Write querry:::----------1
Operations
In mathematics and computer science, an operation is an event that is carried out to satisfy a given task. Basic operations of a computer system are input, processing, output, storage, and control.
Basic Operators
An operator is a symbol that indicates an operation to be performed. We are familiar with operators in mathematics; operators used in computer programming are—in many ways—similar to mathematical operators.
Division Operator
We all learnt about division—and the division operator—in school. You probably know of both these symbols as representing division:
Modulus Operator
Modulus can be represented either as (mod or modulo) in computing operation. Modulus comes under arithmetic operations. Any number or variable which produces absolute value is modulus functionality. Magnitude of any function is totally changed by modulo operator as it changes even negative value to positive.
Operators
In the realm of programming, operators refer to the symbols that perform some function. They are tasked with instructing the compiler on the type of action that needs to be performed on the values passed as operands. Operators can be used in mathematical formulas and equations. In programming languages like Python, C, and Java, a variety of operators are defined.
Write querry:::----------1
![Structured Query Language (SQL) is a language widely used in industry to create, update and
query data in relational databases. You are required to write the SQL code.
Q.6.1
The below sample data in the third normal form was provided by a database
designer. Answer the below questions using this data.
Table: Law Firm
Primary key: Law FirmID (auto number)
All fields are mandatory
LawFirmID
1
2
3
6
Table: Lawyer
Primary key: LawyerID
Foreign key: Law FirmID
LawyerID
7
8
9
Name
1
2
2
Ze Boss Attorneys
Lawyers for the Win
Court Rulez
LawFirmID
3
Surname
Bianchi
Modise
Ferreira
Nkosi
YearIncorporated
2011
2018
2019
Name
Annal
Dikeledi
Piet
Jabulani
Q.6.1.1 Write a SQL statement to create the table Lawyer.
Age
45
57
34
28
Hint: The sample data should give you an indication of the data
types you should use.
Q.6.1.2 Write a SQL statement that will calculate the average age of all the
lawyers that are at least 40 years old.
Q.6.1.3 Write a SQL statement to insert the below row into table LawFirm.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F270b478a-9bce-4ca2-a876-f476f168d98b%2F609fa5d2-6150-4c99-9bde-d540df597ff8%2Ft2jt1yh_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)