Basic SQL work: SQL queries, inserting, searching for fields

Hi there, I need an individual who is fluent in SQL. I have a number of technical questions that need to be answered. You must be fluent in SQL and understand SQL queries. In short, you must be able to: . Query to return all data linked to a primary key . Query to search full database and return information based on a specific keyword - e.g. return all entries in the database that have the name: "ABC" . Query to add or drop data . Query to return total number of entries . Query to make one field equal to another The technical aspect of this is fairly simple. What is most important is that you able to understand English to a high level: you must be able to read and write well. I am going to repeat this, because it seems as though so many people on Freelancer don't actually read the project descriptions properly: ===================================================================================== *** You must be able to read and write English properly. For this project, you will need to write out the correct answers. Essentially, you need to write out the correct SQL query, and then explain why you chose that query (as opposed to another query) and what it does. You will also need to respond a couple of other technical questions about modifying data and managing databases. ** ===================================================================================== Please get back to me as soon as possible as this is on a tight timeline. This is a very straightforward and simple project, but I have gone into a lot of detail because lately I have been disappointed many of the people who get back to me. *****In your responses to me, please demonstrate to me that you understand SQL, and that you have good English language skills. Broken English and incomprehensible responses will be ignored.***** Let me know if you have any questions!