Designing queries help job search accessemplois

On veut développer une application qui gère les rencontres des tournois de Tennis d’une saison donnée. Chaque joueur a un nom et un sexe. Deux joueurs peuvent former une équipe. Un tournoi est identifié par son nom et se déroule dans un pays donné à une date prévue. À la fin d’un tournoi, un jou...

...the front glass. - left side with get - the back side is a wall with box to save the lost items. - a special place for handicapped while chairs. - upper panel written on it queries. - 1 meter down with the branding - a corner for lost children with a table and games - Open source is requested in 3 D max. - the design requested ASAP - more information

1. Retrieve the top 10 employees with highest amount of salaries ,along with their first name ,last name ,title, and salary [se connecter pour voir l'URL] from the highest one. Save the result in new table as EMPLOYEE_DETAILS partitioned by DEPARTMENT. 2. Retrieve list of duplicate last names along with their [se connecter pour voir l'URL] example jon smith and joan smith have the same...

I need simple queries to be wrritten to retrieve from a database.

Hi can you help to solve simple sql queries and help to create simple api using python

We have a number of queries (and slow queries) that do not close. We need a fix about this

In this project you have to do below tasks: 1:ER Diagram 2:Normalization 3:Create tables in oracle and insert some data 4:Answer some sql queries This is not a tough project if you have a knowledge of database [se connecter pour voir l'URL] detail will be shared in a chat box. Moreover,The budget of this project is limited so bid accordingly. Thanks

I have a Visual studio Form written in c++. This is for a business and i need my sales data put into text boxes on my Visual studio form. The database is already integrated and being used in the project. Thanks Aaron

write influx db queries for reading os metrics

Basically create a switch statement that will do different queries based on input inside the mySQL database given. All the tables are given for mySQL.

identify single fact schema, logical schema. Populate sample date is mySQL. Provide OLAP queries

Show evidence of understanding... understanding of various Business Intelligence concepts, through the design of data marts and implementation of OLAP queries. Implementation is performed in R/MySQL environment, while students need to perform OLAP queries and investigate the use of R for performing multidimensional analysis over Big Data Sets.

We are a small manufacturing shop. We are looking for a mid-to high-level of expertise in using the E2 Shoptech system (which is essentially an Access DB) to perform analyze and make data corrections, perform data entry, and produce reports. Expertise in Crystal Reports would be ideal to create new reporting from the system.

Need an SQL expert Budget- 35$

I need a php programmer to create a php script file that performs 10 essential queries on the sql database tables that have information. The results should always be based on 2 specific reference points, which will be user_id and page_id. Please bid with actual cost. this should be able to be inserted into a header file as require once, to be referred

Two short sql queries and three queries that are to be represented in relational calculus, and relation algebra

These are the queries I want you to write. Refer to the attachment for more info. Find all the pairs of musicians (give names) who share an address. Find the songs that are not performed by any musician. Find the musicians (names) who played all the songs written by 'John' (musician author name = 'John'). Find the musicians who perform a song they

I want someone expert to help with the topics and he has good experience with programming

add media queires in my css and add 2-3 javascript, basic level work

We need a MySQL Coder who can write a Stored procedure or Join Queries, I have a PHP code that is timing out so the whole logic of the PHP page has to be written in SQL Queries there are less then 6-8 tables to pull data from. The work has to be done on TeamViewer

Need to convert splunk queries to logstash

Hi i need you to connect and write 9 sql queries asap using SQL server management tool. thanks a

...hosting with 8GB RAM. Issue to be rectified is once there are more calls continuously mysql is not returning/responding which is delaying the queries and very slow responses. There are API calls like 300-500 queries per every 10 seconds,have to fix this and response should be very quick in milliseconds,sometimes its slow and sometimes its fast,when there

...hosting with 8GB RAM. Issue to be rectified is once there are more calls continuously mysql is not returning/responding which is delaying the queries and very slow responses. There are API calls like 300-500 queries per every 10 seconds,have to fix this and response should be very quick in milliseconds,sometimes its slow and sometimes its fast,when there

optimize your PHP script and MySQL queries to reduce the PHP script execution time Website using Magento Ver 2.2 Now the server default php version is PHP 7.1. System PHP-FPM service and PHP-FPM service for the domain are turned off.

Preciso reescrever algumas queries que contém funções e comandos que só o MySQL V8.0 consegue interpretar. Preciso reescrever para versão mais utilizada, que é a 5.6. Ou seja, os comandos ROW_NUMBER(OVER PATITION BY blabla...) precisam ser simplificados. As queries em questão estão anexadas. O que precisa ser feito é a...

I have started a personalised products business & need a website to sell & market my products.

We have a site where the index page loads very slowly due to poorly written queries - here is an overview of its issues. Need someone who can write queries with joins and understands what an index is etc. Here are the issues and suggested corrections: Too many sorts are causing temporary tables. Consider increasing sort_buffer_size and/or read_rnd_buffer_size

We have built a system with WordPress, and are using the Quick Chat plugin (...chat system, it begins to slow down, until the site becomes unresponsive. The hosting company have said it is due to most of the load and slowness coming from inefficient sql queries. It is being hosted on a dedicated VPS. We are looking for someone to resolve the issue.

...utilize an Access Database built prior to 2000. The current version of our database runs safely in 2003 access. We upgraded our Server to MS Server 2013 running in 64 bit. We attempted to just run the database in the new environment and learned that it broke most of the reporting modules. Why we are looking to migrate is to improve client search times.

Write queries to get the required data from mongoDB. Details attached. [se connecter pour voir l'URL]

Require resource to build Hierarchical Transact-SQL Queries Table 1 Geoboundary: Name (city, state, sales territory) Table 2 GeoboundaryType: Name (categorises geoboundary state, city etc) Table 3 GeoboundaryAssociation: FromGeoboundary - ToGeoboundary Table 4 GeoboundaryAssociationType (describes association- city to state) Table3 contains

I am looking for an elasticserch expert who can tune my elasticsearch queries and give recommendations on reducing the cpu and memory usage

Hi I am looking for an SQL expert to write 10 SQL queries We have to agree on a specific date and time, log in at the same time. i will give you access, and work together. LEVEL REQUIRED : EXPERT ! Thanks A.

i want to write 6 simple sql queries see the [se connecter pour voir l'URL]

Running a 2003 access database in 2013 64bit server, need to migrate without breaking functionality. Also, need a special report query, that will utilize several tables, and a unique Identifier of the Birth month, vs. specific birth date on customer record.

Write queries to get the required data from mongoDB. Details attached.

I need a PostreSQL 9.6 syntax expert that can produce simple to medium complexity queries. I'll provide DB access and specifications to what fields of which tables are needed to be queried

...web-form will contain several fields, from 30 to 50 fields. Several fields from the form will use multiple REST queries to web-services like [se connecter pour voir l'URL] (requires sign-up and setting the account from scratch). The REST queries should go deep into service to fetch the historical data. Having experience building stock market/trading/brokerage

Hi, mongoDB ----> PostgreSQL I have 3 collections in mongoDB. This is the data source. I have designed 8-10 different tables in excel (column name, where the data is coming from in Mongodb and data type description). There are roughly 8-14 columns in each table. All inserted data is from either mongoDB or one of the 8-10 tables. Need someone to do the following: -Storage file layout: Creat...

I have a data base manged by a system, I want to create some queries to get information from differents tables, in the same queries do some operations and IFs conditions, then download the data in excel, and create a dashboard to manage a special replenishment of requirements as a Distribution Center.

We are an Io...new units, change configuration settings etc - Store the records from the Units in tables so that the - Run automated queries and send messages to customers when readings are recorded outside paramaters - Provide a customer access (web and app) for customers to see their units, change the nick name and parameters and view their records

We are an Io...new units, change configuration settings etc - Store the records from the Units in tables so that the - Run automated queries and send messages to customers when readings are recorded outside paramaters - Provide a customer access (web and app) for customers to see their units, change the nick name and parameters and view their records

Looking for someone to help me with R-Programming! Please make sure you know what I am talking about before bidding.

We are looking for an SQL Expert to both analyse and optimise our database and code to fix a recurring deadlock and any slow queries. Here is a sample of the deadlock error. Order saving error: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE `catalog_product_entity`

I need help with some api requests POST GET. Documentation included but somewhat vague. Having a hard time figuring out some errors. Need someone to figure it out.

I need optimize Database because is generating the slow MySQL queries and my website goind down for heavy file [se connecter pour voir l'URL] My website is developed with wordpress/woocommerce with template Flatsome My hosting is siteground and below you can see the message about last Technical Support -------------------------- The previous error was caused by

Language known- hindi/English Ability to handle clients effectively

I need 4 query tables created from the uploaded gdb. The queries are: 1. List the players based on the number of home runs hit in their rookie seasons (from high to low). [se connecter pour voir l'URL] the players by the number of seasons played (high to low). (Do not double-count in cases in which a player switched teams mid-season; i.e., 1987, which Sammy Sosa split between

We upgraded mysql to 5.7 and we are getting a few SQL call errors in our PHP script. Here is an example of one of the errors which we need fixed. we expect there to be 5 or so that need fixing, We have traced it back to this "In mysql 5.7 it is required to have the order by fields to be present in the select statement when using DISTINCT" Expression #1 of ORDER BY clause is not in SE...