Find Jobs
Hire Freelancers

SQL Microsoft Access Data

$30-250 USD

Ολοκληρώθηκε
Αναρτήθηκε περίπου 7 χρόνια πριν

$30-250 USD

Πληρωμή κατά την παράδοση
Write the SQL SELECT statement to: 1. List the first and last names of all female directors (39). 2. List the first and last names of all male stars and the title of the movie in which they won an Oscar for a supporting role (72). 3. List the first name, last name and age of every living star. Please see notes* at the end of the documents for using the DATEDIFF function to calculate the age. Do not calculate an age if either the date the star died or the date the star was born does not exist (i.e. is null or an empty string) (708). Include the alias ‘AGE’ on the calculated field. 4. List the titles of the movies released between 1950 and 1975 (end dates should be included) that won the Oscar for best movie; include the title and the year the movie was released in the output (26). 5. List all the directors who starred in the movie they directed. Note: the starnum and dirnum for the director may not be the same value for the same person (54). The result should look like the following: 2 [login to view URL] [login to view URL] mvtitle [login to view URL] [login to view URL] Woody Allen Annie Hall Woody Allen 6. List all movies that made a world-wide gross amount that is more than twice the U.S. gross amount. Include the movie title and the calculated amount in the output (164). To calculate the amount multiple usgross by 2 and subtract from wwgross. 7. List the first and last names of all male stars for which a birth date and birth state is recorded (598) 8. List the title of all R-rate mystery (MYS) movies made after 1950 (14). 9. List the movie number, title and category description for all drama (DRM), mystery (MYS) and biography (BIO) movies (485). 10. List all stars not born in the United States; include the star’s first and last names and name of the country they in which they were born (412). Do not include stars where their country is not recorded.
Ταυτότητα εργασίας: 13770002

Σχετικά με την εργασία

13 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 7 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
Bid Summary Hi, I have gone through your project details and would like to take an opportunity to work on it. Begin experienced in working on several SQL query projects, I can help you to complete efficiently. Project Requirements I can provide you SQL queries for all 10 tasks given in the description. To discuss more, I am waiting for your response to get details of the database. Relevant Skills and Experience I have very much experience in working on several databases like MS Access, SQL Server, Oracle, MYSQL and can handle any SQL tasks related to it. Proposed Milestones $35 USD - Milestone
$35 USD σε 0 ημέρα
4,8 (108 αξιολογήσεις)
6,0
6,0
13 freelancers δίνουν μια μέση προσφορά $94 USD για αυτή τη δουλειά
Avatar Χρήστη
Dear Hiring Manager! I have got your job posting on <SQL Microsoft Access Data> and I am very much interested to work in your project. I am a pro DB expert with more than 8 years working experiences of Database development. your project is no problem for me and it is my main skill. Thank you for your consideration, Best Regards, kkokko
$111 USD σε 3 ημέρες
4,9 (12 αξιολογήσεις)
5,5
5,5
Avatar Χρήστη
Hi there, I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details. Thanks.
$35 USD σε 1 ημέρα
4,9 (105 αξιολογήσεις)
5,6
5,6
Avatar Χρήστη
Hi, I'm a professional Ms Access and VBA developer with strong background in developing and implementing information systems with databases from scratch. I have read your project description and I'll be glad to assist you with whatever you need. These are simple SQL queries that I would like to help get them done. They look like a school assignment and I have done these before, so check my profile for details. I'm looking forward to hearing from you. Regards,
$70 USD σε 0 ημέρα
4,9 (42 αξιολογήσεις)
5,1
5,1
Avatar Χρήστη
Hello, I am a Chinese Developer, Hwang Long I've just read your job posting and I'm very interested. I have a wealth of experience in sql, php, javascript, html5, css, vb, asp.net, angular.js, node.js. I'm very familiar with mysql, mssql, oracle. Please give me a chance to work for you. I can start work right now. Thanks.
$111 USD σε 3 ημέρες
4,3 (4 αξιολογήσεις)
5,7
5,7
Avatar Χρήστη
Hello Sir /Ms, I have received the specification of your project and I am sure to be able to develop it, Please sendme the database Please check the past projects that I have handled, and check my reviews, what my employers have opined about my work. My reviews reflect the reality of the way I work!. I would like to talk to you more about the project. Thanks Experience to apply: VB.NET / C # ASP.net / Win form MySql / Sql server Bootstrap I have 5 years experience and having strong Knowledge of ASP.NET, C#, SQL Server. I will fix any error/bug in related to Microsoft.Net - ASP.Net, C#, SQL Server 2005/2008/2012, JavaScript ,JQuery, Web Services, WCF Services, LINQ , AJAX, Jtable
$30 USD σε 1 ημέρα
4,9 (16 αξιολογήσεις)
4,4
4,4
Avatar Χρήστη
Bid Summary I can write queries in SQL against an existing Access db as requested. I can also design the database. Project Requirements Create SQL for the above requested queries. Relevant Skills and Experience 18+ years of software development. Microsoft Certified Developer and Trainer. Proposed Milestones $88 USD - Complete project Do you have the database already designed and filled with data?
$88 USD σε 3 ημέρες
5,0 (37 αξιολογήσεις)
4,5
4,5
Avatar Χρήστη
Interesting project to work on. Can try hep you with SQL Microsoft Access Data. I'm professional database sysadmin/developer/architect. Thanks.
$35 USD σε 5 ημέρες
0,0 (1 αξιολόγηση)
0,0
0,0
Avatar Χρήστη
A proposal has not yet been provided
$100 USD σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
Expersisse
$222 USD σε 10 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I have successfully delivered many projects in many different company and clients. I have a strong Programming and Management skills and always updates myself with Research and Development of new technologies to strengthen my knowledge and skills. Please visit my profile for more details. https://www.freelancer.com/u/dedycatedinc.html
$30 USD σε 1 ημέρα
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της UNITED STATES
Chicago, United States
4,9
25
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Απρ 17, 2013

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.